Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Functions and Formulas » Need Formula to Show Percentage Met

Need Formula to Show Percentage Met

Previous | Next
Latest post Fri, Jul 30 2010 5:26 PM by toriacat. 2 replies.

  • Fri, Jul 30 2010 4:45 PM

    • toriacat
    • Top 75 Contributor
    • Joined on Fri, Jul 30 2010
    • Posts 12
    • Points 188

    Need Formula to Show Percentage Met

    Reply |Contact

    Hello,

    I have a column (H) that has either "met" or "missed" in the rows based on an IF formula.  The IF formula is comparing the desired date to the completed date:  =IF(D2=C2,"Met","Missed")

    I now need to do a percentage of the met.  I don't think I can do that on column H since that is all text, but I really don't know how to do this.

    Thank you!
    • Post Points: 21

  • Fri, Jul 30 2010 5:02 PM In reply to

    • Omar
    • Top 10 Contributor
    • Joined on Sat, Jan 12 2008
    • Kitchener, ON
    • Posts 128
    • Points 1,823

    Re: Need Formula to Show Percentage Met

    Reply |Contact |Mark as Answer

    This might work for you. Obviously, you need to adjust the range.

    =COUNTIF(H4:H9,"met")/COUNTA(H4:H9)

    Omar Freeman Kitchener, ON
    • Post Points: 21

  • Fri, Jul 30 2010 5:26 PM In reply to

    • toriacat
    • Top 75 Contributor
    • Joined on Fri, Jul 30 2010
    • Posts 12
    • Points 188

    Re: Need Formula to Show Percentage Met

    Reply |Contact |Mark as Answer

    Thank you! This worked perfectly! Big Smile
    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.