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

[Guest]

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?

 

[Bob Phillips]

=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)