Unequal Summing

[Perkett21]

Hello,
I am trying to sum two different numbers that are based off an Airport code- Even though the airport code may show up at the Destination column, it won't necessarily always be in the arrival column. Ex. LAX is a departure but there aren't any arrivals.
I have added an example to the problem.
I will have to do this for thousands of entries, and it will be difficult to sort through them and line them up.
Is there anyway I can sum them using a pivot table?
thanks

[Pepe Le Mokko]

Hi

I see your data, but do not understand what you need.
Can you give an example of result?

[Paul]

Please upload a version of your sample data showing your expected results, and explain why those are the results.

[Perkett21]

I am trying to find the sum of the numbers for each Airport code in the list, whether it is arrival or departure. Essentially, if ACC is 2 in one list and 4 in another, ACC total=6. However, let's say if MBJ=16 in the arrivals list but isn't in the departures list, MBJ total=16.

I just want the total count (right of the airport code) for every time it comes up.

If you need more clarification I can try again.

[Paul]

Based on your new sample layout, in cell I3 use the formula:

=SUMIF($A$2:$D$25,$H3,$B$2:$E$25)

Fill that down as far as needed. Also, your worksheet's Calculation setting is set to Manual. You may want to change it to Automatic. (Office button > Excel Options > Formulas)