Calculating sum of the amounts of each Airports automatically

[Closed]
Report
Posts
2
Registration date
Friday January 11, 2013
Status
Member
Last seen
April 20, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
have you looked into SUMIF