| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find like data in multiple worksheets?
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I find like data in multiple 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) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "3boys1wife" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to find and return value in cell from multiple worksheets | Excel Discussion (Misc queries) | |||
| Find/Replace in multiple worksheets | Excel Discussion (Misc queries) | |||
| Find across multiple worksheets | Excel Worksheet Functions | |||
| How do i update multiple data ranges across multiple worksheets? | Excel Discussion (Misc queries) | |||
| How do I Print the Results of a FIND ALL from multiple worksheets? | Excel Worksheet Functions | |||
Linear Mode
