SUMIF or SUMIFS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff - 29 Jan 2008 14:12 GMT

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

Reply to this Message

kaliman - 29 Jan 2008 14:43 GMT

=if(and(A1>1310;A1<1369);C1;"")

HTH

> Here is what I have
>
[quoted text clipped - 15 lines]
>
> Any suggestions??

Reply to this Message

Jeff - 29 Jan 2008 14:56 GMT

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;"")
>
[quoted text clipped - 19 lines]
>>
>> Any suggestions??

Reply to this Message

Bob Phillips - 29 Jan 2008 16:48 GMT

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

Signature

---
HTH

Bob

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

> 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.
[quoted text clipped - 25 lines]
>>>
>>> Any suggestions??

Reply to this Message