adding columns in a filter

[mojobaabby]

In a large data base can i filter by the invoice number and add only the invoice amounts for those lines appearing in the filter?

[FDibbins]

not sure you can sum that way. do you have a long list of invoices you want to add? perhaps sumifs() or sumproduct() would work better for you?

[Pete_UK]

Yes, instead of using SUM(range) you would use:

=SUBTOTAL(9,range)

and this adds only the visible values. I like to insert a couple of blank rows above the row with the filter on it and put the formula there at the top of the sheet, so that you can apply the filter and then see the effect without having to scroll down to the bottom of the list.

Hope this helps.

Pete

[mojobaabby]

nailed it pete TY