trying to sumif if using 2 column relative to each other

[summer15]

I have 2 columns of numbers and want to sum the third for every column 2 that is less than column 1. I tried the below:

=SUMIF(K3:K12,"<"&J3:J12,L3:L12)
also as an array but it did not work

{=SUMIF(K3:K12,"<"&J3:J12,L3:L12)}

 

[bbott]

Welcome to the board.

Assuming that you want to take the sum of column L where column K is less than column J, try:

=SUMPRODUCT(L3:L12,--(K3:K12 < J3:J12))<j1:j12))< html=""></j1:j12))<>

 

[summer15]

thank you!

 

[bbott]

thank you!

You're welcome.