Average by month, ignore blank fields on date

[acemali]

Hey I have a report sheet and I need to make an average of some % but only looking at the specific month and ignoring when there are no dates in the the row.

For example.

=SUM((MONTH(E15:H15)=9)*E20:H20)/SUM(IF(MONTH(E15:H15)=9,1))

In U9 I have a test formula that is working okay and looking into the table below only when there is dates. But if I change the range E15:I15 formula return error. I need to make an average of some data from bellow based on a specific month but ignoring when there is no date in that specific row.

Thanks for any help.

 

[Takae]

= IFERROR(SUM((MONTH(E15:H15)= 9)* E20:H20)/ SUM(IF(MONTH(E15:H15)= 9,1)),"")
Array formula(Ctrl+Shift+Enter)

 

[Tetra201]

Another approach with a normally entered formula:

=AVERAGEIFS(E20:H20,E15:H15,">=2020-9-1",E15:H15,"<2020-10-1")