| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
summing accross multiple sheets
I have been experimenting with summing accross multiple sheets using
microsoft help for the right formula but I can't get it to work. This is what I want to do and microsoft helps says it should work this way. =SUMPRODUCT(('Sheet2:Sheet3'!D:D=Sheet1!A3)*('Shee t2:Sheet3'!E:E="Y")) However this is what results every time. =SUMPRODUCT(('Sheet2:[Sheet3]Sheet3'!D:D=Sheet1!A3)*('Sheet2:[Sheet3]Sheet3'!E:E="Y")) Can anyone help me please! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can columns be hidden accross multiple sheets in an Excel workboo | Excel Worksheet Functions | |||
| Summing accross sheets | Excel Worksheet Functions | |||
| Sumproduct accross multiple sheets | Excel Discussion (Misc queries) | |||
| Summing across multiple sheets with a twist | Excel Worksheet Functions | |||
| Summing same cell/cells from multiple sheets | Excel Worksheet Functions | |||
Threaded Mode
