Monthwise average

[ashokdd]

I want month wise average as Jan feb march etc.
PQA and PMQ lead time
Marked in yellow field.
attached file for reference.

[shukla.ankur281190]

You are using text in below formula in column AE

Please Login or Register  to view this content.

Don't convert number into text other wise you will get error or wrong result.

Change "1" in to 1 where applicable

Average Formula will automatically work

[ashokdd]

Dear Mr.Shukla,

Thanks for quick response within 15 minutes after posting.
Great.

Thanks

[JohnTopley]

Try

in AR2

=IFERROR(AVERAGE(IF((MONTH($D$3:$D$215)=AR$8)*(YEAR($D$3:$D$215)=$H$1),$AE$3:$AE$215)),"")

copy across

CORRECT column AE as per Shukla's post.

=IF(K3="","",IF(L3="","Under Inspection",IF(X3="","SES Not Sent",IF(C3="Not Booked","",IF(X3<=D3,1,(X3-D3))))))

[ashokdd]

Thank Mr.John for additional help,
nice.