Average every Nth cell in a row not including 0

I am new to this forum, so I hope I'm putting this in the right place, but I have a very large spreadsheet and need help averaging every third cell that is not 0. I have searched forever and have hand no luck with the solutions I've found. The data is horizontal in rows (i.e. A1:L1) not columnar.

Any suggestions as to how I can make that work?

If you have a "header row" with the same text in every row, e.g. header row has "apples" in A1, D1, G1, J1 etc. then the easiest way is to use AVERAGEIFS function, e.g.

=AVERAGEIFS(A2:Z2,A$1:Z$1,"apples",A2:Z2,"<>0")

otherwise this "array" formula will average every third cell starting with the 1st in the range (in this case A2) but excluding non-zero values.

=AVERAGE(IF(MOD(COLUMN(A2:Z2)-COLUMN(A2),3)=0,IF(A2:Z2<>0,A2:Z2)))

confirmed with CTRL+SHIFT+ENTER

Hi and thanks for the quick reply!

I have tried the latter solution to no avail. The average is still taken of the total array (even after ctrl+shift+enter).

the first solution may work, and I can't believe I didn't think to tie it to a header. I will try that and see what I can come up with.

Thank you!

Originally Posted by RJunior

The average is still taken of the total array (even after ctrl+shift+enter).

Can you post the formula you tried, it certainly works for me when I test it.....