I have a table that I'd like to count the number of cells that have values greater than 0, but the cells I want to count are not in order, so I'm confused on what to do for the range.
A simple example of the table is attached.
In this table, I'd like to count cell H5, P5, X5, AF5, AN5, AV5 values that are greater than 0 (the number of cells, not SUM the values). So the result for ROW 5 is 5. ROW 6 result is 4, ...
Repeat for ROW 6, then ROW 7, ....
All suggestions would be greatly appreciated!
Thank you!
Bookmarks