Add cells using a diffrent column as the criteria
 

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

Add cells using a diffrent column as the criteria
 

Try

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

If this post helps click Yes
---------------
Jacob Skaria


"Shaun" wrote:

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