+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : How do I include conditions with COUNTIF formula and present as a PERCENTAGE?

  1. #1
    Registered User
    Join Date
    10-03-2011
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    51

    How do I include conditions with COUNTIF formula and present as a PERCENTAGE?

    Hello, Please can I have some [more] assistance with a couple of formulae? I'm nearly finished now so will slow down on the posts!

    So, in column Q I have data that says whether or not a target has been hit in the form of either "Yes", "No" or blank if certain criteria are met.

    I need to write two formulae......the first one needs to show the number of "Yes" as a proportion of all nonblank entries in column Q, but only if Column I equals "Factory Quality".

    The second needs to show the same as above, but with the additional condition that B must equal "11"

    Can anyone advise, please?

    Thank you

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: How do I include conditions with COUNTIF formula and present as a PERCENTAGE?

    I'm not quite sure what you're after here - the number of non-blank entries in column Q is COUNTA(Q:Q), but it's not clear if you're trying to count all of the non-blanks, or all of the non-blanks where column I is "factory quality", or if that condition only applies to counting the number of "yes" answers in Q.

    Assuming that the percentage you're after is number of "yes" answers in rows where I is factory quality then your formula would be (assuming your data are in rows 2-500) =COUNTIFS(Q2:Q500,"Yes",I2:I500,"Factory Quality")/COUNTIF(I2:I500,"Factory Quality")

    This can then be expanded to take in column B to =COUNTIFS(Q2:Q500,"Yes",I2:I500,"Factory Quality",B2:B500,11)/COUNTIFS(I2:I500,"Factory Quality",B2:B500,11)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1