You can invoke the Longre Subtotal idiom to effect the CountIf
functionality...

=SUMPRODUCT(SUBTOTAL(3,OFFSET(Range,ROW(Range)-MIN(ROW(Range)),,1)),--(Range=TRUE))

would count TRUE's in Range.

Lettie wrote:
Can anyone tell me how I use COUNTIF function *in* a SUBTOTAL function in
order to differentiate the data???

I desperately need it!!!!