Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|