How to count greater than value in filtered list

[Sekar G]

Hi Friends,

I unable to count greater than value in filtered list. cell counting including hidden data.

I Attached excel for your reference.

Please help on this.

Thanks,
Sekar G

[TMS]

Try:

Please Login or Register  to view this content.

[rollis13]

In your column B click the dropdown button and use the "Number Filters" option and choose "Greater than...".

[Sekar G]

Yes. But I need based on column A. if using number filters, showing entire data including robert and praveen.

[Sekar G]

Thank you so much TMS. This is working fine. but formula looking entire column (A2 to XFD11) and getting slowness for large data. there is any option to restrict to work formula for till B column.

[Glenn Kennedy]

No. The formula is ONLY looking at column B. Have you, by any chance, changed the ranges (red) to something excessively large?:

SUMPRODUCT(SUBTOTAL(3,OFFSET(B2,ROW(2:11)-2,))*(B2:B11>5))

Post the EXACT formula you are currently using. How many rows of data do you have?

[TMS]

As Glenn says, it is only looking at column B. Change the 11 to reflect the number of rows of data.

Please Login or Register  to view this content.

Becomes, for example:

Please Login or Register  to view this content.

[rollis13]

Yes. But I need based on column A. if using number filters, showing entire data including robert and praveen.

That's right, you first filter column A by name and then number filter column B.

[Sekar G]

Thanks Glenn and TMS for clarifying. Now no problem. Thanks Again.

[TMS]

You're welcome.