SUM IF
 

I am trying to add all of the values below that fall between 2 and less than
3. Any ideas?

1 10
1.1 10
1.2 10
1.3 10
1.4 10
1.5 10
1.6 10
1.7 10
1.8 10
1.9 10
2 5
2.1 10
2.2 10
2.3 10
2.4 10
2.5 10
2.6 10
2.7 10
2.8 10
2.9 10
3 10
3.1 10
3.2 10
3.3 10
3.4 10
3.5 10
3.6 10


Thanks for any assitance.

Joe

=SUMIF(Range1,"=2",Range2)-SUMIF(Range1,"=3",Range2)

or

=SUMPRODUCT(--(Range1=2),--(Range1<3),Range2)

--

Regards,

Peo Sjoblom


"Joseph" wrote in message
...
I am trying to add all of the values below that fall between 2 and less
than
3. Any ideas?

1 10
1.1 10
1.2 10
1.3 10
1.4 10
1.5 10
1.6 10
1.7 10
1.8 10
1.9 10
2 5
2.1 10
2.2 10
2.3 10
2.4 10
2.5 10
2.6 10
2.7 10
2.8 10
2.9 10
3 10
3.1 10
3.2 10
3.3 10
3.4 10
3.5 10
3.6 10


Thanks for any assitance.

Joe