Results 1 to 5 of 5

Countif and divide by formula needs to become percentage

Threaded View

  1. #1
    Registered User
    Join Date
    04-30-2010
    Location
    Pebble Beach, California
    MS-Off Ver
    2016
    Posts
    44

    Countif and divide by formula needs to become percentage

    OK, stuck again gang!

    I have a spreadsheet where C3 has a capital X as the text in it. Cells E3 through E22 have a value in each of them ranging from 1 to 5. I want to calculate that if C3 has an X, and E3 through E22 has a 5, 4 or 3, then add the number of cells with those values and divide by the total number of cells that E3 through E22 have an X and get a percentage.

    Here's my formula so far; =IF(C3:C22="X",COUNTIF(E3:E22, "5")+COUNTIF(E3:E22, "4")+COUNTIF(E3:E22, "3"))/(C3:C22="X")*100

    I think it's the back end of the formula that is having issues.
    Last edited by argentraven; 10-30-2015 at 04:53 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Translate COUNTIF to a percentage
    By snydert in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-22-2013, 06:23 PM
  2. Getting percentage from columns and raws, divide by 0 error...
    By masta-s in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-09-2013, 04:44 AM
  3. Total value divide from number to percentage?
    By yakabod in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-27-2012, 01:32 PM
  4. Divide two columns then express as a percentage
    By kylie112 in forum Excel General
    Replies: 4
    Last Post: 01-03-2012, 04:05 AM
  5. Replies: 1
    Last Post: 11-09-2011, 04:45 AM
  6. Countif total and percentage
    By NPM2 in forum Excel General
    Replies: 1
    Last Post: 12-03-2009, 02:16 PM
  7. Countif formula - percentage
    By godonlyknows in forum Excel General
    Replies: 3
    Last Post: 02-09-2006, 09:11 AM
  8. divide a no. in a column percentage wise
    By shlomo in forum Excel General
    Replies: 1
    Last Post: 03-28-2005, 02:31 PM

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