Put =SUM in every other cell.

%3CLINGO-SUB%20id%3D%22lingo-sub-1692773%22%20slang%3D%22en-US%22%3EPut%20%3DSUM%20in%20every%20other%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1692773%22%20slang%3D%22en-US%22%3E%3CP%3ETo%20save%20me%20the%20trouble%20of%20deleting%20every%20other%20cell%20with%20a%20%3DSUM%20total%20in%20it%2C%20I%20want%20the%20formula%20where%20i%20can%20drag%20the%20cursor%20along%20a%20line%20and%20it%20skips%20every%20other%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1692773%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1693371%22%20slang%3D%22de-DE%22%3ESubject%3A%20Put%20%3DSUM%20in%20every%20other%20cell.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1693371%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385033%22%20target%3D%22_blank%22%3E%4016Teams%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EExample%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3ECopy%20cells%20E13%20to%20BX13.%3C%2FSPAN%3E%3CBR%20%2F%3E%20%3CSPAN%20class%3D%22%22%3EInsert%20in%20the%20desired%20row%20at%20column%20E.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3E-----------------%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3Eanother%20variant%20would%20be%20with%20VBA%20code%3A%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3ESub%20Copy_Cells_Nlino%20()%0A%0A%20%20%20%20%20Dim%20NextEmpty%20As%20Long%0A%20%20%20%20%0A%20%20%20%20%20NextEmpty%20%3D%20Table1.Cells%20(2%2C%201)%20.End%20(xlDown)%20.Row%20%2B%201%0A%20%20%20%20%0A%20%20%20%20%20Table1.Rows%20(%222%3A%206%22).%20Copy%0A%20%20%20%20%20Table1.Cells%20(NextEmpty%2C%201)%20.Select%0A%20%20%20%20%20ActiveSheet.Paste%0A%0AEnd%20Sub%0A%0A'From%20German%20translate%2C%20untested.%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 Replies
Highlighted

@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.

Highlighted

@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.