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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
=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)
 
Back
Top