How can I use sumproduct with different size ranges?
 

Is this possible or is there another function that I can use?

Thanks,

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,

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,

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,