Subtotal for text fields



I have a one page report that shows, by department, the status of each
section within that department, for Budget, schedule, customer
satisfaction etc. in a Red/Yellow/Green style.

At present all we do is have a table at the top that displays % of
Red, Amber and Green overall.


The above are repeated for Yellow and Green

What I am trying to achieve is that, when I filter on a specific
department, I get the % Red, Yellow and Green (totaling 100%) for that
department alone.

I've looked at Subtotal(3,A$8:A$37) and that shows me the number of
records in a department, but i'm uncertain how to then get the totals
I need, and maintain the ability to get the overall totals when I
"Select All", and turn the filter off.


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