| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare cells in column to criteria, then average next column cell | Excel Worksheet Functions | |||
| find duplicate data in diffrent column | Excel Discussion (Misc queries) | |||
| Need formula that will sum cells in a column bases on criteria in other cells. | Excel Worksheet Functions | |||
| Linking cells with a diffrent sheet with 2 cells | Excel Worksheet Functions | |||
| add a column only if 5 other cells on the row satisfy criteria | Excel Worksheet Functions | |||
Hybrid Mode
