Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
hello,
please help me to accomplish a simple formula... i have many different named range, to simplify the data here goes below... my range name for search criteria: MRO <A2:A200 MRO1 <B2:B200 my range name for summing result something like a calculator MRO2 <C2:C200 MRO3 <D3:D200 MRO4 <E3:E200 In a formula like this, its okey =sumproduct(--(MRO0),--(MRO12),MRO2) then, if i use a cell say A1, then i place the range name like "MRO2" or "MRO3", or "MRO4" ---- one at a time... then,how to write it down in a formula something like this: =sumproduct(--(MRO0),--(MRO12),"&A1") i need to save space so i may prefer to use A1 as the holder for my result range. i hope it may make sense....trying to gain more simplicity. thanks and regards, driller -- ***** birds of the same feather flock together.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using named 3-D ranges | Excel Discussion (Misc queries) | |||
Sumproduct using named ranges and multiple criteria | Excel Discussion (Misc queries) | |||
Named Ranges in VBA | Excel Discussion (Misc queries) | |||
3D Named Ranges | Excel Worksheet Functions | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) |