- Registration date
- Sunday September 12, 2010
- Last seen
- November 5, 2020
So if I understand you correctly the result for SEF 263 should be 170+44+80=294
Why don't you use SUM at the bottom of each column (or anywhere else) and then refer to that cell in sheet 2.
To do that go to C4 of sheet 2, type =, then select the cell on sheet 1 which you put the SUM formula in and hit enter.