How can I use sumproduct with different size ranges?

[Fen]

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

Thanks,

 

[vezerid]

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

 

[Bob Phillips]

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)

 

[RagDyer]

One possibility:

=SUMPRODUCT((A2:A20=K1)*(B2:B20=K2)*(C1:F1=K3)*C2:F20)