I am trying to calculate average On Time Delivery %, however i only want the percent to be included in the average calculation if the number in the "days aged" column is greater than or equal to 0 ("On Time" = 0). I came up with this formula below but I'm getting a divide by 0 error, any help would be greatly appreciated!
=AVERAGEIF(H5:H32,I5:I32>=0)
**Please see attached file**
Hi,
And can you confirm there are no zeros in I5:I32.
Upload the workbook if not so we can see the problem in context
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
I have conditional formatting in the "I" column so that 0 comes up as "On Time". Here is the workbook thanks!
You haven't got the correct syntax,. try this version
=AVERAGEIF(I5:I32,">0",H5:H32)
...but that will include all your "blank" rows because you have large values in column I for those
Audere est facere
That works great thanks!
Normally this sheet will be updated weekly so those extra rows will be deleted.
Thank you so much though I've been trying to get that right for like three hours!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks