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.

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


"broush" wrote:

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.

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

--
HTH

Bob Phillips

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

"broush" wrote in message
...
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.

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

=COUNT(YourRangeName)

Vaya con Dios,
Chuck, CABGx3



"broush" wrote:

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.

Thanks for the help!

"Gary''s Student" wrote:

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


"broush" wrote:

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.

Here's another way...

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

Hope this helps!

In article ,
broush wrote:

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.