Subtotal Question
Posted by Tanya on October 19, 2001 7:00 PM
I have a file with a separate workbook for each year,
so I have 5 worksheets in this workbook. Each worksheet has
customer names, part numbers, and sales quantities. There
will be multiple customer listings, i.e. 1 customer can have
purchased many different parts. What I need to do is subtotal
for each customer, and do this for all 5 worksheets. Then,
I need to put this information onto 1 new worksheet. The
summarized data from each worksheet will be side-by-side on
the new worksheet.
Is there a way to do this easily? I could subtotal each worksheet,
but is there an easy way to transfer this data without manually
copying and pasting each subtotal?
Posted by Don C on October 22, 2001 12:08 PM
SUMIF will do what you need.
In your new worksheet, you create a list of all customer names (Pivot tables or advanced filtering can help with this). I'd probably have five columns, one for each year with a sumif for each year, then total those five, just to keep the formulas simple, but it could be done by adding five sumif statements in one statement.
