+ Reply to Thread
Results 1 to 4 of 4

How to add 1 if the text= a specific value (value example: 60+)

  1. #1
    Registered User
    Join Date
    06-14-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    12

    How to add 1 if the text= a specific value (value example: 60+)

    Hi! I'm having issues. I have a list of values:

    <19
    20's
    30's
    40's
    50's
    60+

    And they are randomly dispersed through the column, I want to add only the values that are equal to those to create a total.

    So I want to add all of the <19 and have that represented by a number.

    Like if the cell equals <19 then add 1 to come up with a total. So if there are five <19 values in the column then the total would be 5.

    Is this doable?

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

    Re: How to add 1 if the text= a specific value (value example: 60+)

    Try the countif function

    =COUNTIF(A1:A100,"<19")

  3. #3
    Registered User
    Join Date
    06-14-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: How to add 1 if the text= a specific value (value example: 60+)

    Works perfectly! Thank you very much!!

  4. #4
    Registered User
    Join Date
    06-14-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: How to add 1 if the text= a specific value (value example: 60+)

    Okay, another question. What if I have a column beside the original column that has a number. So say it's like this:
    1 <19
    2 50's
    1 <19
    3 20's

    I want to add the amount of 20 year olds so you'd need to add cell b3 if cell c3=20's
    How do I do that?

+ 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