Counting question

[mach3]

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

 

[Asala42]

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

 

[Aladin Akyurek]

Also, normally entered:

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

Aladin