Forum Discussion

16Teams's avatar
16Teams
Copper Contributor
Sep 21, 2020

Put =SUM in every other cell.

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.

excel

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Sep 21, 2020

    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.

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Sep 21, 2020

    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.