adding cells in autofilter


S

Sal

I have a list of a few thousand rows. It is a list of vendors with credits
and debits. Is there a way to get a total of the credits and debits for each
individual vendor? I looked at autofilter but can't figure how to add each
column up. Also can the totals still work as rows keep being added to the
spreadsheet. For instance, I have a list of transactions for the month of
July and create the formulas. Then I add August's transactions to the list.
Will the total formula's include the added rows for august or do I need to
use a new range? Hope this was clear enough.
 
Ad

Advertisements

D

Don Guillett

It may help to look in the help index for SUBTOTAL and notice the special
codes for filtered data. Then use a range larger than necessary or the
necessary range and insert BEFORE the last row. ie you could have a dummy
row with a color or something as the last row.
 

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