Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: statistics of text

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have two columns. One column contains the names of the people working in an organization. The second column contains the people's functions within the org:

    NAME-----------JOB
    Joe-----------Analyst
    Jim-----------Manager
    Mary----------Secretary
    Jackie--------Manager
    Christie------Analyst

    What I want to achieve is the following:
    Analysts:---2
    Managers:---2
    Secretary:--1

    Which function or formula do I need to use in order to be able to count how many manager, analyst, and secretary are in the JOB column. Can someone help me out?

    Thanks a lot



    [ This Message was edited by: hoz on 2002-04-09 05:04 ]

  2. #2
    New Member
    Join Date
    Apr 2002
    Posts
    30
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =COUNTIF(C1:C10,"Analyst")

  3. #3
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    A simple Pivot table would be ideal for this.



  4. #4
    Board Regular eliW's Avatar
    Join Date
    Mar 2002
    Posts
    1,919
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi hoz,
    You can use from menu Data|Subtotals
    on column "Job" and you'll get what you want.
    Eli

    [ This Message was edited by: eliW on 2002-04-09 05:21 ]

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    THANK YOU for all ur help.

    What works best is the countif function. I tried the COUNT, DCOUNT, COUNTA, and DCOUNTA functions but to no avail.
    The COUNTIF function is perfect...thanks for all your help

    hoz

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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