Calculating sum of the amounts of each Airports automatically

Closed
SALWA ATALLAH Posts 2 Registration date Friday January 11, 2013 Status Member Last seen April 20, 2013 - Jan 11, 2013 at 11:56 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 11, 2013 at 04:26 PM
Hello,
I have TWO tables such as below,according to the First Table :the first column (Airport name) the second column is ( the amounts in USD)

the first table :

Airport name U.S.D
ALY 111,447.70
ALY 559,557.23
LXR 12,827.16
LXR 279,720.62
HRG 1,353.77
HRG 1,187,334.08
SSH 8,417.65
SSH 2,900,602.08
TCP 6,363.41
TCP 90,279.68
TCP 18,567.52


the second table:

airport name the total Amount of each airport
ALY 671,004.93
LXR 292,547.78
HRG 1,188,687.85
SSH 2,909,019.73
TCP 115,210.61

According to the second table, the first Column (airports name)and the second Column ( the total amounts of a specific airport).
All I need is to make the second column in the second table calculates the SUM of the amounts of each Airports automatically with reference to the first table.

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jan 11, 2013 at 04:26 PM
have you looked into SUMIF
0