summing filtered data

J

johngarlich

I have a number of columns that present detail data from invoices. I want to be able filter the data, (filter by salesperson for instance) and then only sum those rows that are visible. In essence I want to sum the cells that have a row height > 0. However, I don't know a way to do this. It seems simple, but I don't see anything in the help section that directs me. Thanks for your help.
 
K

Kieran

The =Subtotal() function has a method that sums only visible cells.

Look it up in online help as it is fairly well documented.

From memory the autosum button will set this up for you by defaul
where you have filtered list - provided the filter is in place
 

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

Similar Threads

Filtering data from a non-continuous list 3
VLookup sum multiple matches 1
Filtering data 2
Sum after Filter, Count after Fliter 2
Sum a column of filtered data 1
Using SUM(INDIRECT()) 2
Sum of filtered data 3
sum of multiple rows 2

Top