How do I count non-contiguous cells?

[Guest]

I am trying to use the countif function to add non-contigous cells but I am
getting an error. I want to count 4 cells on a sheet that have a value
greater than 0.

 

[Guest]

COUNTIF() doesn't work on disjoint ranges. The usual approach is to use
several COUNTIF()'s and add them up.

 

[Bob Phillips]

=SUMPRODUCT(COUNTIF(INDIRECT({"A2","B7","H9","I1"}),">0"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Assign a RangeName to your non-contiguious range and try this......

=COUNT(YourRangeName)

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Thanks for the help!

COUNTIF() doesn't work on disjoint ranges. The usual approach is to use
several COUNTIF()'s and add them up.

 

[Domenic]

Here's another way...

=INDEX(FREQUENCY((A2,B7,H9,I1),0),2)

Hope this helps!