Sir_BlahBlah
New Member
- Joined
- Apr 17, 2020
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
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!
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!