On 2002-10-09 03:50, svg1967 wrote:
i need a formula to sum if the value in the data is greater than 1 and less than 5
Let A2:A20 house the numeric data of interest, E1 1 -the first condition, and F1 5 -the second condition.
=SUMIF(A2:A20,">"&E1)-SUMIF(A2:A20,">="&F1)
should give you the desired sum.