COUNT ON NON-CONTINOUS CELLS

  • Thread starter Thread starter Gerard Sanchez
  • Start date Start date
G

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!
 
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
 
Here you are

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



--


Regards,


Peo Sjoblom
 
Back
Top