SUMIF or SUMIFS

[Jeff]

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]

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]

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]

Oh, and you can use full-column references with SUMIFS:

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