I have the following formula which averages values from different columns:

=AVERAGEIFS($DL$9:$DL$2000,$G$9:$G$2000,GS12)+AVERAGEIFS($DN$9:$DN$2000,$G$9:$G$2000,GS12)+AVERAGEIFS($DR$9:$DR$2000,$G$9:$G$2000,GS12)+AVERAGEIFS($DX$9:$DX$2000,$G$9:$G$2000,GS12)+AVERAGEIFS($DZ$9:$DZ$2000,$G$9:$G$2000,GS12)+AVERAGEIFS($DV$9:$DV$2000,$G$9:$G$2000,GS12)+AVERAGEIFS($DT$9:$DT$2000,$G$9:$G$2000,GS12)+AVERAGEIFS($DP$9:$DP$2000,$G$9:$G$2000,GS12)

I noticed the 'AVERAGEIFS' function is including Zeros as part of the result - which is skewing my overall average.

Is there a way to EXCLUDE the zero from the average WITHOUT needing to insert "<>0" inside each sub-formula as I have over 30 of these formulas throughout my spreadsheet?

Thanks in advance