Add cells using a diffrent column as the criteria

[Shaun]

I am trying to take a shipping report and add the cost of each package that
the weight is between 1.0 -2.0 lbs. so that I can figure out the cost of the
group prices so that I can see where I am getting my price breaks. So I
would like to use the criteria A1-A5 >=1.1 - <=2.0 so that it will add C1 and
C3 because they are in the 1.0 – 2.0 lbs. so my returned value is $4.20. Any
help would be great!

A B C D
1 1.1 $2.10
2 5.6 $7.20
3 1.6 $2.10
4 7.8 $8.57
5 5.9 $7.20

 

[Jacob Skaria]

Try

=SUMPRODUCT(--(A1:A5>=1.1),--(A1:A5<=2),C1:C5)

If this post helps click Yes