Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sumproduct with Range Names
Hi, I have been using range names for each row in my worksheet and now I am trying to use sumproduct but I can't get it to work using the range names as it takes the entire range, not just the current column. I have rangenamed by columns as well so I tried using those to define it but with no success...any help would be great, maybe a UDF could do it?? -- soteman2005 ------------------------------------------------------------------------ soteman2005's Profile: http://www.excelforum.com/member.php...o&userid=29078 View this thread: http://www.excelforum.com/showthread...hreadid=510528 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES | Excel Discussion (Misc queries) | |||
Using NAMES in SUMPRODUCT giving error | Excel Worksheet Functions | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Dynamic range names, multiple criteria, sumproduct | Excel Discussion (Misc queries) |