Forum Discussion

BriWork's avatar
BriWork
Copper Contributor
Aug 31, 2023
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 want for a cell to be the sum of the cell C2 from sheet 2 and D12 from sheet10 only. I do not want cells in sheets between 2 and 10 to be included in the sum. What formula should I use?

 

Question 2: I am looking for a way to sum two cells over two different sheets (in this case, the cell number is the same in both sheets).

I found the formula = SUM(first:last!cell) but the problem is that if there are sheets between the first and the last one, it will sum every value within the selected cell over all the sheets, but I only want the specific cell in ONLY the two selected sheets to be summed, not every sheet contained within as well. What formula should I use?

 

Thank you!

  • BriWork 

    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.

  • BriWork 

    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.

Resources