Survey data template problem

[Pogie58]

I have a spreadsheet and I can not figure what I am doing wrong with the formula when I copy it to another range of cells.

Here is the formula
=AVERAGE(IF(MOD(ROW('Survey Input'!G$2:G$2012)-ROW('Survey Input'!G$2),10)=0,'Survey Input'!G$2:G$2012,0))

When I moved it to the next group of cells it does not work, and I have a third group of cells to add it to. See below
=AVERAGE(IF(MOD(ROW('Survey Input'!G$5:G$2015)-ROW('Survey Input'!G$5),10)=0,'Survey Input'!G$5:G$2015,0))

The next group would be G8 G2018

 

[jeffreybrown]

I believe you have an array formula there which requires Ctrl + Shift + Enter

 

[Pogie58]

Sorry but I am Excel stupid and I have no idea what you mean.

 

[jeffreybrown]

Certain formulas are called CSE formulas which is a shortcut name for an array formula.

Ctrl
Shift
Enter

Select the cell with the formula and press F2

This will put you in the edit mode for that formula

For a normal formula you would just press Enter, but in this case you will hold down the Shift key along with the Ctrl key and then press enter.

If done successfully you will see the formula wrapped in {}. Do not try an add these manually.

 

[Pogie58]

I was able to do it but it caused the calculations to stop