Forum Discussion

mnlowery's avatar
mnlowery
Copper Contributor
Apr 06, 2022

Need help with replicating a formula

Staring formula in cell F4 is 

=IFERROR(AVERAGE(Daily!F4:L4), "0")

 

I need G4 to have the formula =IFERROR(AVERAGE(Daily!M4:R4), "0")

 

Then H4 to have =IFERROR(AVERAGE(Daily!T4:Z4), "0")

excel
Formulas and Functions

1 Reply

  • Starrysky1988's avatar
    Starrysky1988
    Iron Contributor
    Apr 06, 2022
    F to L 7 cells, T to Z 7 cells in your formula. If I understand correctly, the second formula must be like below.
    =IFERROR(AVERAGE(Daily!M4:S4), "0")

    If I'm correct, you may write the formula in F4 as below and drag formula to right.
    =IFERROR(AVERAGE(OFFSET(Daily!$F4,0,(COLUMN(A1)-1)*7,1,7)),0)