Countif over several worksheets
 

I'd like to have a countif equation over the range Sheet1:AA2, Sheet2:AA2,
Sheet3:AA2 and I want it count anything that is not equal to 2. How would I
write this.

Thanks,
Barb Reinhardt

Countif over several worksheets
 

COUNTIF() does not work over dis-joint ranges.

Try:

=(Sheet2!AA2<2)+(Sheet3!AA2<2)+(Sheet1!AA2<2)
--
Gary's Student


"Barb Reinhardt" wrote:

I'd like to have a countif equation over the range Sheet1:AA2, Sheet2:AA2,
Sheet3:AA2 and I want it count anything that is not equal to 2. How would I
write this.

Thanks,
Barb Reinhardt

Countif over several worksheets
 

=SUMPRODUCT(COUNTIF(INDIRECT("Sheet"&{1,2,3}&"!AA2 "),"<2"))

--
HTH

Bob Phillips

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

"Barb Reinhardt" wrote in message
...
I'd like to have a countif equation over the range Sheet1:AA2,
Sheet2:AA2,
Sheet3:AA2 and I want it count anything that is not equal to 2. How
would I
write this.

Thanks,
Barb Reinhardt