| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic name reference in SUMPRODUCT
Formula:
SUMPRODUCT((ACCOUNT)*(AMOUNT)*(Period="2006-08")) works fine... it sums the amounts where period equak 2006-08 but Forumla: SUMPRODUCT(($A$2)*(AMOUNT)*(Period="2006-08")) doesn't work... $A$2="ACCOUNT" ACCOUNT=(A2:A65535) Data table Account Amount Period 7830 23400 2006-08 3220 -99900 2006-12 3440 -7100 2006-08 3560 2700 2006-08 8540 7900 2006-12 Is there anyone that could help, plse Best Regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup - dynamic range reference? | Excel Discussion (Misc queries) | |||
| I want to be able to create a dynamic reference in excel, for exam | Excel Worksheet Functions | |||
| Reference / Copy Dynamic Data | Excel Discussion (Misc queries) | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
| Dynamic reference to a sheet | Excel Worksheet Functions | |||
Threaded Mode
