=SUMPRODUCT(COUNTIF(INDIRECT({"A1:C3","D4:F6","G7: I9"}),"Y"))

Nicely done, Bob! It works fine in my test.

***********
Regards,
Ron

XL2002, WinXP-Pro


"Bob Phillips" wrote:

=SUMPRODUCT(COUNTIF(INDIRECT({"A1:C3","D4:F6","G7: I9"}),"Y"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Kurt Swanson" wrote in message
...
Is there any way to specify multiple disjoint ranges in one COUNTIF?

I.e. something like COUNTIF((A1:C3,D4:F6,G7:I9),"Y")

I want to avoid COUNTIF(A1:C3,"Y") + COUNTIF(D4:F6,"Y") + ...
--
© 2005 Kurt Swanson AB