Put =SUM in every other cell.

[16Teams]

To save me the trouble of deleting every other cell with a =SUM total in it, I want the formula where i can drag the cursor along a line and it skips every other cell.

[#2]

@16Teams 

Example:
Copy cells E13 to BX13.
Insert in the desired row at column E.

-----------------

another variant would be with VBA code:

Sub Copy_Cells_Nlino ()

     Dim NextEmpty As Long
    
     NextEmpty = Table1.Cells (2, 1) .End (xlDown) .Row + 1
    
     Table1.Rows ("2: 6"). Copy
     Table1.Cells (NextEmpty, 1) .Select
     ActiveSheet.Paste

End Sub

'From German translate, untested.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

[#3]

@16Teams 

Perhaps you mean

=IF(D$1="Pts",SUM(D2:D12),"")

in D13 and drag it to the right. Same for other rows with total.

In Totals sheet you may use INDEX/MATCH to pickup sums from Mavan Teams sheet, but I'm not sure what is the logic for different Totals tables.