Sum values greater than x and less than y in a column
 

This is relatively simple and I can't figure it out. I have two cells (B1
and C1). B1 contains the low value and C1 contains the high value. I have
data in column A and I want to sum all the values in the column that are
between the two values in B1 and C1? Does this make sense?

Sum values greater than x and less than y in a column
 

=SUMIF(A:A,""&B1)-SUMIF(A:A,""&C1)

--
HTH

Bob

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

"Rookie_User" wrote in message
...
This is relatively simple and I can't figure it out. I have two cells (B1
and C1). B1 contains the low value and C1 contains the high value. I
have
data in column A and I want to sum all the values in the column that are
between the two values in B1 and C1? Does this make sense?