How to Count only visible filered cells "FP"

P

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
 
J

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top