Sorry, yes, it provides the count of the cells >0 rather than the count of the rows with a cell value >0. My mistake. I was looking for a total in which a row with two values >0 is only counted once.
Tony Valko's formula above works for my purpose.
Sorry, yes, it provides the count of the cells >0 rather than the count of the rows with a cell value >0. My mistake. I was looking for a total in which a row with two values >0 is only counted once.
Tony Valko's formula above works for my purpose.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks