How do I find like data in multiple worksheets?

  • Thread starter Thread starter 3boys1wife
  • Start date Start date
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.
 
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)
 
Back
Top