Forum Discussion

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

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)