Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use sumproduct with different size ranges?
Is this possible or is there another function that I can use?
Thanks, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use sumproduct with different size ranges?
It defeats the raison d' etre for SUMPRODUCT if you use arrays of
different lengths. Maybe there is a different function, but this depends entirely on what you want to do. HTH Kostis Vezerides On Dec 11, 1:49 pm, Fen wrote: Is this possible or is there another function that I can use? Thanks, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use sumproduct with different size ranges?
What possible reason do you have for doing this?
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Fen" wrote in message ... Is this possible or is there another function that I can use? Thanks, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use sumproduct with different size ranges?
One possibility:
=SUMPRODUCT((A2:A20=K1)*(B2:B20=K2)*(C1:F1=K3)*C2: F20) -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Bob Phillips" wrote in message ... What possible reason do you have for doing this? -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Fen" wrote in message ... Is this possible or is there another function that I can use? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help on sumproduct of named ranges | Excel Worksheet Functions | |||
dynamic ranges with sumproduct | Excel Worksheet Functions | |||
Sumproduct and Ranges | Excel Discussion (Misc queries) | |||
sumproduct between 2 ranges | Excel Discussion (Misc queries) | |||
Compare ranges different size | Excel Worksheet Functions |