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?

2 Answers

Consider the following formula.

=(K2>0)+(T2>0)+(AC2>0)+(AL2>0)+(AV2>0)

1

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

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

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