Hi!

I am trying to figure out how to modify the following array formula in order to make Excel ignore blank cells when averaging:

=AVERAGE(IF(MOD(ROW(OFFSET(Data,Start-1,0))-ROW(OFFSET(OFFSET(Data,Start-1,0),0,0,1,1)),EveryN)=0,OFFSET(Data,Start-1,0),FALSE))

The modification in the thread at http://www.excelforum.com/excel-form...ank-cells.html looks very simple but I can't figure out how to apply it to the above formula. I am trying to average every nth data value (specified in cell 'EveryN') in the list 'Data' given a certain start position (specified in cell 'Start') - as per the example at http://www.cpearson.com/excel/EveryNth.aspx.

Please could you help me out? I would be very grateful for your advice.

Kind Regards,
James.

PS I replied to the thread posted above but it doesn't seem to show up on the main page so I am starting a new topic.