View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe K
 
Posts: n/a
Default calculating total in a range of numbers

I would like to calculate the sum of all values that are greater than 20 and
less 50 in the following data set. Can anyone give me the formula for this
computation.

5
5
19
20
22
25
45
51
60

This is what I am after but with a larger data set. 20+22+25+45 = 112