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
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