LinkBack URL
About LinkBacks
I want month wise average as Jan feb march etc.
PQA and PMQ lead time
Marked in yellow field.
attached file for reference.
Monthwise average
I want month wise average as Jan feb march etc.
PQA and PMQ lead time
Marked in yellow field.
attached file for reference.
You are using text in below formula in column AE
Formula:
=IF(K3="","",IF(L3="","Under Inspection",IF(X3="","SES Not Sent",IF(C3="Not Booked","",IF(X3<=D3,"1",(X3-D3))))))
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
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Dear Mr.Shukla,
Thanks for quick response within 15 minutes after posting.
Great.
Thanks
Last edited by ashokdd; 04-05-2018 at 09:32 AM. Reason: spell mistake
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))))))
Thank Mr.John for additional help,
nice.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks