Add column A when the Values in Column B are less than the Values in Column C.

[Sir_BlahBlah]

I am trying to figure out a way add the values in column A if the corresponding value in column B is less than the value in column C.
I thought I had this figured out with a simple =SUMIF(B1:B5, "<"&C1:C5, A1:A5)

However I noticed that the results were changing depending on which cell I put the formula in, and I'm not sure why. I show this in the picture, cells E1 through G8 all have the exact same formula.

I'm hoping this can be done simply without having to deal with arrays.

Thanks for your help!

 

[etaf]

TRY
=SUM(IF(B2:B6<C2:C6,A2:A6))
use Control+Shift+Enter to set as an array formula

{=SUM(IF(B2:B6<C2:C6,A2:A6))}

 

[Sir_BlahBlah]

Thanks buddy, that works.

its just a pain dealing with so many array calculations in a workbooks the sizes i deal with.

 

[etaf]

=SUMPRODUCT((B2:B6<C2:C6)*A2:A6)
Does this work as a non array formula

 

[Sir_BlahBlah]

That it does, as does
=SUMPRODUCT(--(B2:B6<C2:C6),A2:A6)

It would seem that I don't fully grasp the versatility of SUMPRODUCT as I was literally using =SUMPRODUCT(--(B2:B6<C2:C6)) earlier to count everything.