How do I find like data in multiple worksheets?

3

3boys1wife

I have multiple worksheets within 1 workbook. Each worksheet has the exact
layout. I enter multiple vendor invoices on a weekly basis on each worksheet
and would like to get a total of each vendor for the year. These totals
would come various entries from some or all worksheets.
 
L

Luke M

You'll prb have to setup some SUMIF functions on each worksheet, but you
could then use a 3D reference to sum them all together onto your summary
sheet.

Example of 3D sum:
=SUM('Sheet1:Sheet2'!A1)
 

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

Sum Multiple Worksheets, same named cell 1
Spreadsheet summary automatically referrences totals of worksheets 2
Totaling cells in multiple worksheets 4
Identical Cells in Multiple Worksheets in one Workbook. 4
Working out VAT owed 1
How do I sum totals from mulitple worksheets 1
How do I count instances of a reference? 1
running total from the same field on multiple sheets as i add she 2

Top