Forum Discussion

TracieH's avatar
TracieH
Copper Contributor
May 06, 2022

Cross Page Formulas

How do I get a total from various worksheets to add up in one worksheet?

For example if I have a file with 5 worksheets and totals in various columns in worksheet 1, 2 3 & 4, how do I get all those totals to add up automatically in the last worksheet ?

1 Reply

  • Anonymous's avatar
    Anonymous
    =SUM(Sheet1! A14,Sheet2! B17)

Resources