Using IFERROR, SUBTOTAL AND AVERAGE IF TOGETHER

I am trying to make a report and trying to use IFERROR, SUBTOTAL AND AVERAGEIF together but unable to use so
Averageif because if there is Zero, it should be ignored and not added to the average
Iferror so that I do not get ?NAME errror etc

I am trying to use SUBTOTAL so that in case I hide the column because I do not want the data of the row in the calculations and hence in the result
At present my formula which works, looks like this
=IFERROR(AVERAGEIF(B13:P13,"<>0"),0)

Please advice how do I incorporate SUBTOTAL function in the formula so that if I hide the entire column, the data is ignored.
Am I going around in circles?

Thank you very much for your reply, anything I can do for hidden columns?

I changed the format from column to rows so that I can use subtotal

Also tried using it =IFERROR(SUBTOTAL(109,(AVERAGEIF(D7:D21,"<>0"))),0)

but I get error, I am not an expert, but find excel interesting

TRIED EVEN =IFERROR,SUBTOTAL(109,(AVERAGEIF(D7:D21,"<>0")), 0)
I am not able to get it correct

Originally Posted by :) Sixthsense :)

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

The Sky blue cell are the focus,
The cells above them can sometimes be blank or with "NO" in them so if the cells do not have number, it wont count it

updated file

Thank you for your help, there how ever seems to be one limit. that there has to be something filled in first row. If I put 0 in frist row, it does not work

using this

=IFERROR(AVERAGE(IF(SUBTOTAL(109,OFFSET(P7,ROW(P7:P26)-ROW(P7),0,1))>0,P7:P26)),0)

using this

=IFERROR(AVERAGE(IF(SUBTOTAL(109,OFFSET(P7,ROW(P7:P26)-ROW(P7),0,1))>0,P7:P26)),0)