question about numbers.app and forumla

Discussion in 'Mac Apps and Mac App Store' started by mrgreeneyes, Jun 23, 2014.

  1. mrgreeneyes macrumors 6502

    Joined:
    Oct 7, 2007
    Location:
    Orleans,Canada
    #1
    Hey guys, I'm trying to figure out something.

    I'm trying to figure out what formula to use to count, specific text in the cells that i have entered information?


    thanks

    i tired:

    countif
    countifs
    count
    counta
     
  2. CylonGlitch macrumors 68030

    CylonGlitch

    Joined:
    Jul 7, 2009
    Location:
    SoCal
    #2
    Count cells that are not blank :

    Cell A1 is '=counta(B)'
    B1 = 'one'
    B2 = 'two'
    B3 = 'three'
    B4 = 'four'

    The value in A1 will be 4 (remove the ' around the values).

    Is this what you're looking for?
     
  3. mrgreeneyes thread starter macrumors 6502

    Joined:
    Oct 7, 2007
    Location:
    Orleans,Canada
    #3
    no, I'm trying to figure out how to have my spread sheet.

    like this

    a formula to count how many times the word "text" is written and same for the numbers

    Cell A1 "text"
    Cell A2 "text"
    Cell A3 "text"
    Cell A4 "1234
    Cell A5 "1234"
     
  4. CylonGlitch macrumors 68030

    CylonGlitch

    Joined:
    Jul 7, 2009
    Location:
    SoCal
    #4
    That is a lot more complex. The way I have done something like this in the past is I create another column with an IF statement. Say I make Column A for the items and start on row 2. Then Column B is the search for the specific item with Row 1 being the name.

    ---- XYZ 123
    XYZ
    XYZ
    XYZ
    123
    123
    123
    123

    Then I can do Column B2:xxx as something like this, '=if($B$1 = A2, 1, 0)' From there I could then add up the 1's in Column B. Column C for the next item I'm searching for.

    Not sure if this is the easiest way, but it works for me. :D
     

Share This Page