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

Calculate Complete %

Lasantha

Member
Dear All ,

Kind look into the attached file. Can you give me a formula to calculate completed % of each customer.
(need count of "Done")

thank you.
 

Attachments

  • EXCEL FILE.xlsx
    16.7 KB · Views: 7
not sure I understand correctly.
Try this.
=(COUNTIF(C4:M4,"Done"))/(COUNTA(C4:M4))
 

Attachments

  • EXCEL FILE.xlsx
    16.2 KB · Views: 3
Back
Top