Forum Discussion
Formula range with gaps
Hi, I am trying to work out the average of the yellow cells but do not know how to specify a range of multiple cells; I also need the average to exclude zeros.
=AVERAGE(IF(MOD(COLUMN(B:L),4)=0,B2:L2))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.