I have K2, T2, AC2, AL2, and AV2 with numbers in them. I want to count how many of those are greater than zero. For instance, K2 is 4, T2 is 17, AC2 is 0, AL2 is 3, and AV2 is 6. I would expect an answer of 4, because 4 out of 5 cells is greater than zero. I have tried multiple formulas, all returning errors. So if I use countif, and my range is the cells K2, T2, AC2, AL2, and AV2 and my criteria is >0 I get an error. Help please?
Consider the following formula.
It's not pretty: