help with a SUMIF function

[kestrel]

hi all,

I am currently working with SUMIF functions: e.g:

=SUMIF($5:$J$5000,$E$15,$C$5:$C$5000)

what I now want to do is to have two criteria's for this function, that would refer to two different columns. How would I do this?

many thanks
Leon

[olasa]

This solution should give you an idea:

=SUMPRODUCT(--(J5:J5000=E15),--(K5:K5000=F15),C5:C5000)

Ola Sandström


Note:
I removed the $ to make it easier to read.
--(...) is used to convert a True/False to 1/0