Support Board
Date/Time: Fri, 09 May 2025 23:35:37 +0000
Post From: Spreadsheet Count Values Greater Than Zero
| [2023-05-28 19:26:08] |
| user_xyz - Posts: 479 |
|
I want to count/sum any value greater than 0 as 1 across 12 columns AB:AM. Is the only way to create 12 helper columns O:Z with =IF(AB>=1,1,0) etc. Then in column AA =SUM(O:Z) to count the number of instances? Since SC doesn't use sumif, countif or array functions I'm trying to streamline this without using a mega number of helper columns. AB AC AD AE AF.... 0 123 5 17 0 O P Q R S.... 0 1 1 1 0 AA Result would be 3 |