Sum cell from last row - multiple sheets

Vatechtigger

Hello. Looking to sum a specific cells from multiple sheets. Have 5 sheets. Columns are the same across all five sheets. Looking to take the last entry, say for column 1, across all five sheets and sum those values. That value would live in another sheet. Any ideas?

Thanks

Shawn

Paul Newcome

To pull the data for the last row...

=INDEX({Sheet 1 Column to Pull From}, COUNTIFS({Sheet 1 Column to Pull From), OR(@cell <> "", @cell = "") - 10)

Do that for each of your sheets and add them together.

=INDEX({Sheet 1 Column to Pull From}, COUNTIFS({Sheet 1 Column to Pull From), OR(@cell <> "", @cell = "") - 10) + INDEX({Sheet 2 Column to Pull From}, COUNTIFS({Sheet 2 Column to Pull From), OR(@cell <> "", @cell = "") - 10) + INDEX({Sheet 3 Column to Pull From}, COUNTIFS({Sheet 3 Column to Pull From), OR(@cell <> "", @cell = "") - 10) + .............................................