Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2008
    Location
    Paraburdoo, Western Australia, Australia
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formular help (2007)

    Hi
    I need a formula that will count the number of times a name occurs in a spreadsheet ?
    I am hopeless with formula's please help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formular help (2007)

    Welcome to Woody's Lounge!

    Let's say that you have names in A1:A100, and you want to know how often the name "Sharty" occurs. The following formula will do that:
    <code>
    =COUNTIF(A1:A100,"Sharty")
    </code>
    Adjust the range and the name to your situation.

  3. #3
    New Lounger
    Join Date
    Nov 2008
    Location
    Paraburdoo, Western Australia, Australia
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formular help (2007)

    Thank you Hans

    I am really new at this and I have made another post <img src=/S/sorry.gif border=0 alt=sorry width=15 height=15> I thought the first one did not work.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •