Sum if
 

I want to check the column B2 to B265. If observations in that column are
smaller than A2 then I want to sum them up. The sum is then placed in C.
Please help me out!

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

Thanks alot!

Sum if
 

=sumproduct((b2:b265<a2),c2:c265)

--
Don Guillett
SalesAid Software

"Arne Hegefors" wrote in message
...
I want to check the column B2 to B265. If observations in that column are
smaller than A2 then I want to sum them up. The sum is then placed in C.
Please help me out!

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

Thanks alot!

Sum if
 

In the USA version, I'd use:

=SUMIF($B$2:$B$265,"<"&A2,$C$2:$C$265)

so maybe:

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




Arne Hegefors wrote:

I want to check the column B2 to B265. If observations in that column are
smaller than A2 then I want to sum them up. The sum is then placed in C.
Please help me out!

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

Thanks alot!

--

Dave Peterson

Sum if
 

Assuming you want one total, try this formula in cell C2 and put the less
than formula e.g.( <23) in cell A2.
=SUMIF(B2:B265,A2)


Assuming you want a running total in column C, then place this formula in
cell C2 and copy it down column C. Make sure cell C1 is equal to -0-. In
this case cell A2 would be just a value e.g.(23).
=IF(B2<$A$2,C1+B2,C1)

Happy Trails

"Arne Hegefors" wrote:

I want to check the column B2 to B265. If observations in that column are
smaller than A2 then I want to sum them up. The sum is then placed in C.
Please help me out!

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

Thanks alot!