Sum if

[nada]

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!

 

[SteveO59L]

Instead of a definate value, why not reference a cell where you can have a variable ?

 

[Norie]

nada

I'm afraid your 2nd formula didn't show correctly in the post so this is a guess.

=SUM.IF($B$2:$B$265;"<" & A2;$C$2:$C$265)

 

[nada]

yes! that is what I want but i cannot get the syntax to work. I try writing:

=SUMMA.OM($B$2:$B$265;<A2;$C$2:$C$265)

but that gives me error. Please help me!!

 

[nada]

missing code

=SUMMA.OM($B$2:$B$265;<A2;$C$2:$C$265)

is the code that i am trying to write.

 

[nada]

hi Norie! no i did not get that to work. But that is what I want to do. please please help me!

 

[Domenic]

Try...

=SUMMA.OM($B$2:$B$265;"<"&A2;$C$2:$C$265)

Hope this helps!