How to Count only visible filered cells "FP"

  • Thread starter Thread starter Jim
  • Start date Start date
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
 
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 -
Click to expand...

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.
 
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 -
Click to expand...

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.
 
Back
Top