Sum if

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arne Hegefors - 22 Sep 2006 15:20 GMT

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!

Reply to this Message

Don Guillett - 22 Sep 2006 16:07 GMT

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

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

>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.
[quoted text clipped - 3 lines]
>
> Thanks alot!

Reply to this Message

Dave Peterson - 22 Sep 2006 16:33 GMT

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)

> 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.
[quoted text clipped - 3 lines]
>
> Thanks alot!

Signature

Dave Peterson

Reply to this Message

tplourde - 22 Sep 2006 17:16 GMT

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

> 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.
[quoted text clipped - 3 lines]
>
> Thanks alot!

Reply to this Message