+ Reply to Thread
Results 1 to 6 of 6

Calculate percentages of multiple responses from a list

  1. #1
    Registered User
    Join Date
    01-29-2016
    Location
    england
    MS-Off Ver
    2010
    Posts
    3

    Calculate percentages of multiple responses from a list

    Hi,

    I've created lists with multiple possible answers e.g. types of exercise carried out - running, cycling, none
    I want to calculate the percentage of people that are exercising overall, regardless of which type. I know I could just do the percentage of people that said "none" by doing: =COUNTIF(b2:b60, "none")/COUNTA(b2:b60) and do it backwards from there but I want my work to look more neat.
    How do I add multiple options? I tried =COUNTIF(b2:b60, "cycling", "running")/COUNTA(b2:b60) but it doesn't work

    I'd appreciate any help, thank you!

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Calculate percentages of multiple responses from a list

    hi and welcome to the forum
    I think you need to use
    =sum(countif(B2:B60,{"Cycling","Running"})

    in Curly braces you can type the criteria such as
    {"criteria 1","criteria 2","criteria 3","criteria 4" and so on}
    Attached Files Attached Files
    Last edited by hemesh; 01-29-2016 at 05:28 AM. Reason: attachment
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  3. #3
    Registered User
    Join Date
    01-29-2016
    Location
    england
    MS-Off Ver
    2010
    Posts
    3

    Re: Calculate percentages of multiple responses from a list

    Hi, thanks for your help but I've just tried it and it's come up with 1000% even though I know there are some responses where the answer was n/a or not recorded

  4. #4
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Calculate percentages of multiple responses from a list

    =COUNTIF(b2:b60, "cycling", "running")/COUNTA(b2:b60)


    replace red part with
    =sum(countif(B2:B60,{"Cycling","Running"})

    see the attachment in above post

  5. #5
    Registered User
    Join Date
    01-29-2016
    Location
    england
    MS-Off Ver
    2010
    Posts
    3

    Re: Calculate percentages of multiple responses from a list

    That's fixed it, thank you so much!

  6. #6
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Calculate percentages of multiple responses from a list

    You are welcome and thanks for the feedback and Rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Unique list from multiple responses to multiple criteria
    By 0Stump3 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-12-2015, 12:11 PM
  2. [SOLVED] Calculate average score based on number of responses
    By Nurket in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-04-2015, 08:02 AM
  3. lookup one value over multiple sheets & return multiple responses
    By rsagar-patt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-01-2012, 11:30 AM
  4. [SOLVED] Calculate multiple percentages from a list of values
    By zabuzaa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-23-2012, 05:16 PM
  5. Multiple If Then responses
    By TAXX in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2010, 05:31 PM
  6. Look at multiple yes, no responses
    By korr77 in forum Excel General
    Replies: 3
    Last Post: 03-15-2010, 07:58 AM
  7. [SOLVED] Input Box Asking for Multiple Responses
    By Paige in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-16-2006, 08:45 AM

Tags for this Thread

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