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

Thread: Counting question

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    245
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    column 1 has priority levels in validation listboxes (e.g., High, Medium, Low).

    i have an information box that returns the count of all Highs, Mediums, and Lows.
    =CONCATENATE("HIGH = ",COUNTIF($E$9:$E$30,"High"))

    i've changed the priorities so that there are now High 1, High 2, High 3, High 4, Medium, Low.

    i need the same information box that returns the count of all Highs (regardless of 1,2,3,4). i tried a combination of countif's and LEFT($E$9:$E$30,4)="High", but no dice.

    can someone offer the answer? thanks.

    mach3

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,312
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    G'day,

    Something like this array formula maybe (hit Ctrl+Shift+Enter instead of just 'enter' to get the brackets):

    {=SUM(IF(LEFT($E$9:$E$30,4)="High",1,0))}

    Adam

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,030
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    Also, normally entered:

    =SUMPRODUCT((LEFT($E$9:$E$30,4)="High")+0)

    Aladin

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
  •