+ Reply to Thread
Results 1 to 3 of 3

Count formula return all answers in 1 cell

  1. #1
    Forum Contributor
    Join Date
    08-10-2015
    Location
    Sarasota, FL
    MS-Off Ver
    MS 365
    Posts
    77

    Count formula return all answers in 1 cell

    I have a column of names

    Big Bird
    Big Bird
    Big Bird
    Cookie Monster
    Grover Monster
    Cookie Monster
    Big Bird

    I need a formula that will provide the following result in a single cell

    Cookie Monster 2; Grover Monster 1

    I do not need to know about the number of times with Big Bird

    Is that possible? Or do I need to do each one in it's own cell?

    Thanks!

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Count formula return all answers in 1 cell

    Personally, I would do each in their own cell.
    Seems like how many times Cookie Monster exists in a range might be useful information later on..

    So 1 cell for each
    Say A1:A7 is that list of text strings.
    In B1, =COUNTIF(A1:A7,"Cookie Monster")
    In C1, =COUNTIF(A1:A7,"Grover Monster")

    Then you can get the end result with
    ="Cookie Monster "&B1&"; Grover Monster "&C1

  3. #3
    Forum Contributor
    Join Date
    08-10-2015
    Location
    Sarasota, FL
    MS-Off Ver
    MS 365
    Posts
    77

    Re: Count formula return all answers in 1 cell

    Names are different caregivers associated with clients. I have to do this formula multiple times because I need to know how many of Cookies and Groovers for each client....I was hoping to not have to add rows to my report, but I might be able to do it at the end of the columns and then do the end result formula in the one cell under the client...that might work. Thanks!

    Client A
    Cookie Monster 2; Grover Monster 1
    Client B
    Cookie Monster 4; Grover Monster 0
    Client A
    Cookie Monster 1; Grover Monster 5

+ 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. [SOLVED] Formula to look up Combinations of Headings and return a Count to a Cell
    By hammer2 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-15-2015, 09:22 PM
  2. [SOLVED] Count the number of matches in a row of one word answers with a row of correct answers
    By flammer4 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-03-2012, 01:17 PM
  3. Replies: 3
    Last Post: 03-29-2012, 05:28 PM
  4. IF to return multiple text answers depending on value in cell
    By CKD777 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-14-2011, 06:54 PM
  5. Formula to return multiple answers matching criteria
    By taketwo in forum Excel General
    Replies: 3
    Last Post: 12-06-2010, 12:34 PM
  6. Formula with multi-cell answers
    By FrznWltDsny in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-16-2007, 08:07 AM
  7. [SOLVED] I need to return one of three answers in a cell
    By Kath in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-03-2006, 05:40 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