SUM IF

[Joseph]

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

 

[Peo Sjoblom]

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

or

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