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)
 

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

Counting multiple memberships 1
Multiple Worksheet in Excell Workbook 1
How do I count instances of a reference? 1
How do I copy the page set up from one worksheet to another? 2
How do I move multiple tabs in multiple workbooks to a master? 3
Totaling cells in multiple worksheets 4
Displaying multiple non-adjacent cells with 1 criteria 3
How do i create a cumulative worksheet 1

Back
Top