| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT FOR MULTIPLE SHEETS
How can I use a formula like:
=SUMPRODUCT(--(Jan!$H:$H=$A3)*--(Jan!$J:$J=B$1)*--(Jan!$J:$J<=B$2),Jan!$J:$J) for multiple sheets? Following formula is not working: =+SUMPRODUCT(--(Jan:Dec!$H:$H=$A3)*--(Jan:Dec!$J:$J=B$1)*--(Jan:Dec!$J:$J<=B$2),Jan:Dec!$J:$J) It is resulting into a #Name? error. Any suggestions? Thanx in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter | Excel Worksheet Functions | |||
| Sumproduct on multiple sheets...please help??? | Excel Worksheet Functions | |||
| sumproduct for multiple sheets | Excel Worksheet Functions | |||
| sumproduct looking at multiple sheets | Excel Worksheet Functions | |||
| sumproduct from multiple sheets | Excel Worksheet Functions | |||
Threaded Mode
