How to Count only visible filered cells "FP"
 

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

How to Count only visible filered cells "FP"
 

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

On Dec 7, 12:43*am, Jim wrote:
Is there a formula which will count only visible filtered cells which
equals "FP"?

How to Count only visible filered cells "FP"
 

=SUBTOTAL(3,column_range)


"Jim" wrote:

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

How to Count only visible filered cells "FP"
 

On Dec 6, 7:20*pm, Pete_UK wrote:
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

On Dec 7, 12:43*am, Jim wrote:



Is there a formula which will count only visible filtered cells which
equals "FP"?- Hide quoted text -

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

How to Count only visible filered cells "FP"
 

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


"Jim" wrote in message
...
On Dec 6, 7:20 pm, Pete_UK wrote:
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

On Dec 7, 12:43 am, Jim wrote:



Is there a formula which will count only visible filtered cells which
equals "FP"?- Hide quoted text -

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

How to Count only visible filered cells "FP"
 

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

"Jim" wrote in message
...
Is there a formula which will count only visible filtered cells which
equals "FP"?