Combining SUMIFS and filter SUBTOTALS

E

elsmed

I have a table of cost data that I summarize for certain cost categories with
SUMIFS functions. I have filters on the table to look at specific criteria
such as a time period or a particular vendor. Plus I use the SUBTOTAL
function to show the filtered column totals. I want to see subtotals of the
filtered data for the cost categories that I've summarized using the SUMIFS.
For example, I want to filter on a vendor and see the number of and invoices
and the dollar amount of the invoices across the different phases of a
project. How can this data be summarized on the fly as I choose different
filter criteria?
 

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