Hi! I want to check column B. If there are observation in B that are smaller than A2 then I want to sum them and place them in C. This formula works for me:
=SUM.IF($B$2:$B$265;"<2";$C$2:$C$265)
However then I cannot have a variable instead of 2. I want to write:
=SUM.IF($B$2:$B$265;<A2;$C$2:$C$265)
but that does not work. Please help! Thanks alot!
=SUM.IF($B$2:$B$265;"<2";$C$2:$C$265)
However then I cannot have a variable instead of 2. I want to write:
=SUM.IF($B$2:$B$265;<A2;$C$2:$C$265)
but that does not work. Please help! Thanks alot!