| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
3d array not working
I need an array that looks across multiple sheets and gives a sum product
based on an account number. I have tried the following formula that should work, but returns a #Ref. The formula I am trying is =SUMPRODUCT(--('ME:[Budget]Budget'!B484:B510=Total!B484),('ME:[Budget]Budget'!C484:C510)) The account number I need to match is in Total b484, and I need to add the numbers in c484:c510 that matches this account number asross the sheets ME through Budget. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array fomrula not working... | Excel Worksheet Functions | |||
| CountIf Array not working | Excel Discussion (Misc queries) | |||
| quirky array not working | Excel Worksheet Functions | |||
| Array formula not working | Excel Worksheet Functions | |||
| Working with array equations | Excel Discussion (Misc queries) | |||
Threaded Mode
