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