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.
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.