SUMIF or SUMIFS

  • Thread starter Thread starter Jeff
  • Start date Start date
J

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??
 
If I do this, I get a message saying the formula contains an error. WHen I
hit okay, the cursor goes back to the formula, and highlights the 1310.
Column A should be a decimal value so i do not have the 1310 in quotes.

any suggestions???
 
=IF(AND(A1>1310,A1<1369),C1,0)


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top