S
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
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