Badly Need Help on Excel Formula

[blackorchids2002]

Hi Masters, just to make it understandable please see below.

AWB #7082013260 has 3 records. Each 3 records for the same way bill number has different actual weight and dimensional weights. To get the billable weight, I used the formula MAX to get the maximum weight between actual weight and dimensional weight.

In the example, you will see the billable weight for each record but I want the billable weight to be shown as one input.

AWB#	ACTUAL WEIGHT	DIMENSIONAL WEIGHT	BILLABLE WEIGHT
7082013260	875	800	875
7082013260	781	800	800
7082013260	850	800	850

<tbody>
</tbody>

The output would be as per below. Kindly note that the records are not sorted out so it may be placed into different lines/rows in the excel sheet.

AWB #	ACTUAL WEIGHT	DIMENSIONAL WEIGHT	BILLABLE WEIGHT
7082013260	875	800	2,525
7082013260	781	800
7082013260	850	800

<tbody>
</tbody>

Thanks

<tbody>
</tbody>

 

[Dave Patton]

Thanks Dave. i works ..

I just need to understand the formula. Why do you need to put a double minus sign?

=SUMPRODUCT(--(A4:A10=F3),--(B4:B10 >= C4:C10),(B4:B10))+
SUMPRODUCT(--(A4:A10=F3),--(B4:B10 < C4:C10),(C4:C10))

The double minus coerces the True or False to 1 or 0 that SumProduct can use.

I am not sure what you are asking in your other question. Was your question answered in the other thread?

Dave