• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Percentage

I

Indranee

New Member
Hai,

Please refer to the excel file I have attached. The file is for Purchase order issuing tracking. In the file in column L "PRF Receive Time" and column O "Date Distribute". I want the percentage between the column L and column O.

Below is how my manager request to me.

Timely distribution of Purchase Order (PO) - to have 80% of total distributed PO within 4 working days of receiving PRF from PO tracking report.

First my manager asked in days between column L and column O I can done it. Now she request in percentage.

Please help me on this.

Thanks in advance.
 

Attachments

  • Purchase Order (Responses) - January.xlsx
    37.4 KB · Views: 3
Indranee

Firstly, Welcome to the Chandoo.org Forums

I think Q3 should be =O3-L3 and expressed as a number not as a percentage
Copy Q3 down

There are COUNTIFS(Q3:Q69,">4") entries above 4 days
= 8
There are a total of COUNT(Q3:Q69) = 67 records

so the average less than 4 is
=1-(COUNTIFS(Q3:Q69,">4")/COUNT(Q3:Q69))

that can be expressed as a percentage currently = 88%

see attached file:
 

Attachments

  • Purchase Order (Responses) - January.xlsx
    35 KB · Views: 3
You must log in or register to reply here.
Back
Top