SUMIF or SUMIFS
 

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??

SUMIF or SUMIFS
 

On Jan 29, 2:14 pm, Jeff wrote:
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??

Using the data above in a spreadsheet the formula would look something
like this:-

=SUMIF(A3:A13,"<1369",C3:C13)-SUMIF(A3:A13,"<=1310",C3:C13)

If you need more details, theres more of an explanation he

http://www.vertex42.com/ExcelTips/ex...-function.html

HTH

Regards,
Matt Richardson
http://teachr.blogspot.com

SUMIF or SUMIFS
 

On Jan 29, 2:14 pm, Jeff wrote:
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??

Try this:-

=SUMIF(A3:A13,"<1369",C3:C13)-SUMIF(A3:A13,"<=1310",C3:C13)

Also have a butchers at this site which explains more on how to use
SUMIF in this way (ie including greater than or equal to, less than or
equal to etc etc)

http://www.vertex42.com/ExcelTips/ex...-function.html

HTH.

Regards,
Matt Richardson
http://teachr.blogspot.com

SUMIF or SUMIFS
 

Hi,

Maybe

This one excludes 1310 & 1369
=SUMIF(A2:A12,"1310",C2:C12)-(SUMIF(A2:A12,"=1369",C2:C12))

This one includes those numbers
=SUMIF(A2:A12,"=1310",C2:C12)-(SUMIF(A2:A12,"1369",C2:C12))


Mike

"Jeff" wrote:

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??

SUMIF or SUMIFS
 

If you're using Excel 2007:

Inclusive of 1310 and 1369

=SUMIFS(C2:C12,A2:A12,"=1310",A2:A12,"<=1369")

Excluding 1310 and 1369:

=SUMIFS(C2:C12,A2:A12,"1310",A2:A12,"<1369")

--
Biff
Microsoft Excel MVP


"Jeff" wrote in message
...
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??