How to Count only visible filered cells "FP"

[Jim]

Is there a formula which will count only visible filtered cells which
equals "FP"?

 

[Pete_UK]

One way is to fill a helper column with 1 and use:

=SUBTOTAL(9,column_range)

then apply your filters as required, including the column where your
"FP" exists.

Hope this helps.

Pete

 

[Teethless mama]

=SUBTOTAL(3,column_range)

 

[Jim]

One way is to fill a helper column with 1 and use:

=SUBTOTAL(9,column_range)

then apply your filters as required, including the column where your
"FP" exists.

Hope this helps.

Pete



- Show quoted text -

Sorry but I should have been more clear. A filtered column will have
several text codes such as "FP", "PB", "TM" etc. I am looking for a
formula which will count each "FP". I can then convert it to count
the other text codes as needed.

 

[T. Valko]

Try something like this:

The full unfiltered range is B2:B100.

=SUMPRODUCT(SUBTOTAL(3,OFFSET(B2:B100,ROW(B2:B100)-ROW(B2),0,1)),--(B2:B100="FP"))

--
Biff
Microsoft Excel MVP

One way is to fill a helper column with 1 and use:

=SUBTOTAL(9,column_range)

then apply your filters as required, including the column where your
"FP" exists.

Hope this helps.

Pete



- Show quoted text -

Sorry but I should have been more clear. A filtered column will have
several text codes such as "FP", "PB", "TM" etc. I am looking for a
formula which will count each "FP". I can then convert it to count
the other text codes as needed.

 

[Ashish Mathur]

Hi,

You can apply the filter on FP as well and then use =subtotal (2,range)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com