This formula works as long as it is not located within A1:I9

=SUMPRODUCT(--((A1:C3:D4:F6:G7:I9)="Y"))

Does that help?

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

XL2002, WinXP-Pro


"Kurt Swanson" wrote:

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