Hi,

I have a dataset where I need to average every 5th column. However, I have missing values in some columns, which disrupts the average when using the normal formula method to look at every nth row:

(=AVERAGE(IF(MOD(COLUMN($A$1:$O$1),2)=0,$A$1:$O$1,0))

I would like the formula to only take a cell into account if it has a non-zero value, and is therefore non-empty. Can anyone help with this please?

Cheers.