yogi_Compute Average Of Non-Zero Cells Of Every Nth Row In A Specified Range

Google Spreadsheet   Post  #2329

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-26-2017

question by: John Mahler

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/tQ_-7GYm-Xg;context-place=mydiscussions

Average every 19th cell, except when cell is zero
Hello all, 

I have searched the forum and I am unable to figure this out. Though there are seemingly answers out there, they do not work for my sheet.

I need to average every 19th row, starting with row 23, within a given column.  I have tried things that look like the following:

=averageif(IF(MOD(ROW(C23:C1500)-4,19)=0,C23:C1500),"<>0")

But that doesn't work. If I try to use the ArrayFunction operator, then I get an error.

I don't know how to link my sheet onto here so you can see my data.

Please help!