COUNT ON NON-CONTINOUS CELLS

[Gerard Sanchez]

Hi,

Is there a way for me to get a count of cells (NOT in a RANGE) that have
values greater than zero (0).

i.e.

A1=1
C3=0
D4=3
E2=0
E5=2

Result = 3

Thank you!

 

[John]

Hi Gerard
Try this =COUNT(IF(A1:C5>0,A1:A5))
This is an array formula you must press CTRL+SHIFT+ENTER to enter the formula.
If successful in the Formula Bar you can see the curly braces at both ends like
{=COUNT(IF(A1:C5>0,A1:A5))}. do not type them in yourself.
HTH
John

 

[T. Valko]

Try this...

=INDEX(FREQUENCY((A1,C3,D4,E2,E5),0),2)

 

[Peo Sjoblom]

Here you are

=SUMPRODUCT(COUNTIF(INDIRECT({"A1","C3","D4","E2","E5"}),">0"))



--


Regards,


Peo Sjoblom