0

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?

3

Consider the following formula.

=(K2>0)+(T2>0)+(AC2>0)+(AL2>0)+(AV2>0)
  • Very interesting use of an inherent true/false test! – Raystafarian Dec 21 '13 at 5:29
0

It's not pretty:

=SUM(IF(K2>0,1),IF(T2>0,1),IF(AC2>0,1),IF(AL2>0,1),IF(AV2>0,1))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.