Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SUMIF or SUMIFS

5 views
Skip to first unread message

Jeff

unread,
Jan 29, 2008, 9:14:30 AM1/29/08
to
Here is what I have


Col A Col B Col C
1310 3 3,463.00
1315 3 740
1330 3
1369 3 -178
1375 3 -105
1640 3 110
135 4
1310 4 1,460.00
1315 4 1,521.00
1375 4 -65
1310 6 3,284.96


I am trying to figure out a way to add column C to a new cell if
Column A is between 1310 and 1369.

Any suggestions??

Pete_UK

unread,
Jan 30, 2008, 9:18:55 AM1/30/08
to
Try this:

=SUMPRODUCT((A1:A200>=1310)*(A1:A200<=1369)*(C1:C200))

Adjust the ranges if necessary, but you can't use complete columns
(unless you have XL2007).

Hope this helps.

Pete

ilia

unread,
Jan 31, 2008, 9:44:22 AM1/31/08
to
The Excel 2007 SUMIFS version is like this:

=SUMIFS(C1:C200,A1:A200,">=1310",A1:A200,"<=1369")

But the SUMPRODUCT version is backwards-compatible.

ilia

unread,
Jan 31, 2008, 9:48:10 AM1/31/08
to
Oh, and you can use full-column references with SUMIFS:

=SUMIFS(C:C,A:A,">=1310",A:A,"<=1369")

0 new messages