Forum Discussion
Solved
Formula: Sum two different cells over two different sheets
Hi! Question 1: I am looking for a way to sum two different cells over two different sheets in a spreadsheet with multiple sheets. See example below: Spreadsheet contains 10 sheets. In sheet 1, I w...
Question 1:
=SUM('Sheet 2'!C2, 'Sheet 10'!D12)
Substitute the real names of Sheet 2 and Sheet 10.
Question 2:
Basically the same:
=SUM('Sheet 2'!A10, 'Sheet 10'!A10)
This sums cell A10 on Sheet 2 and Sheet 10.
Question 1:
=SUM('Sheet 2'!C2, 'Sheet 10'!D12)
Substitute the real names of Sheet 2 and Sheet 10.
Question 2:
Basically the same:
=SUM('Sheet 2'!A10, 'Sheet 10'!A10)
This sums cell A10 on Sheet 2 and Sheet 10.
- Thank you so much!
