| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF across multiple worksheets
I am collating a summary stock movement which using the sumif function i.e
SUMIF Sheet1!b$1:b$500,a5,a$1:a$500) Is there a way to shorten the formula as I have presently 40 sheets for one week which is causing me problems space wise (and hurts the eyes when looking at the formula) as the a5 is a rolling cell and there are 945 varying cells in the summary worsheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Functions across multiple worksheets | Excel Worksheet Functions | |||
| Sumif with multiple worksheets | Excel Worksheet Functions | |||
| Update multiple worksheets | Excel Discussion (Misc queries) | |||
| how do I arrange multiple worksheets from the same workbook | Excel Discussion (Misc queries) | |||
| Extracting data from multiple worksheets into a list | Excel Worksheet Functions | |||
Threaded Mode
