Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Aug 2004
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula for Counting (Excel 97)

    Can someone please help me write a formula. I have a list of users in Column A and a list of their locations in Column B. I want to create a formulat that will tell many how users in Column B reside in a specific location. Thanks!

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Formula for Counting (Excel 97)

    Not sure exactly what you need, how about:
    <pre>=COUNTIF(B:B,"Location")</pre>

    This will count the occurences of "Location" (change to the text string desired) in col B.

    Steve

  3. #3
    Star Lounger
    Join Date
    Aug 2004
    Posts
    57
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula for Counting (Excel 97)

    That's exactly what I needed thanks!

Posting Permissions

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