Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using named ranges for formula abbreviations
I would like to use named ranegs, if possible, to replace the function
SUMPRODUCT with the abbreviated nam "SP." I created the named range SP and called it sumproduct, but I have not been able to make it work. this function =SP&"(--($H$4:$H$21=J5),--($F$4:)$F$21))" gives me as a result sumproduct(--($H$4:$H$21=J5),--($F$4:)$F$21)) but does niot give me the result of that formula. any help would be greatly appreciated. Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named Ranges | Excel Worksheet Functions | |||
UPDATED - Referencing named Ranges within a Nested IF formula | Excel Worksheet Functions | |||
Help to adapt Formula syntax to work with Dynamic Named Ranges | Excel Worksheet Functions | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |