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)
 
Top