The range you want to run a count. Lets suppose that the area you apply
AutoFilter is A4:F100 which also includes the labels. Lets suppose that
you filter say on column B and you want to count TRUE's in column D.
D5:D100 would be the range you feed to the formula.

Lettie wrote:
Okay, cool. So, which Range and Row do I use for this? the same one I'm
trying to differentiate?


"Aladin Akyurek" wrote:


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!!!!