Summary sheet count when filter on

Paul Molloy

Hi,

I am currently using a summary sheet. I have used the following command in one of my fileds

=COUNTIF([% Complete]:[% Complete], <0.99)

But i want to count when one of the columns has a filter. This command still counts all even when i have the filter on / off.

thanks for your help

Andrée Starå

Hi @Paul Molloy

Unfortunately, it's not possible at the moment to reference the filter, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could have a cell where you change it to filter in the formula(s) as well.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!