Forum Discussion

john_lloyd's avatar
john_lloyd
Copper Contributor
Jun 04, 2020

Have a formula that repeats to an exact pattern

Hi

 

I am trying to create a simple 'sum' formula on a worksheet that pulls through data from other sheets in the same work book. That bit is simple enough, but i need the pattern of the data to be Sheet1!A1+Sheet2!A1+Sheet3!A1 etc in the first cell, then the next several cells need to follow that pattern but move to cells C1, then E1 etc

 

Is there a way i can make this happen?

 

Thank you all

Formulas and Functions

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jun 04, 2020

    john_lloyd 

    It depends on where these next several cells are and what means etc

     

    If, for example, in A3 is =SUM(Sheet1:Sheet3!A1), you may copy paste it to C3 and it'll be =SUM(Sheet1:Sheet3!C1)

     

    If next cell is down, or next to the right, or something else - perhaps some formula could be used.

Resources