Need help with replicating a formula

Copper Contributor

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")

1 Reply
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)