I have countif, which works great. However due to the export from our system other values are in the cells that include the text LOW,MED or HIGH meaning no count as it is specifically looking for LOW,MEd or HIGH.

Here is an example of other text/numbers

eg 33 LOW or 67 HIGH

can i modify the formula to pick the LOW,MED,HIGH up?

=COUNTIF(B2:B798,"LOW")
=COUNTIF(B2:B798,"MED")
=COUNTIF(B2:B798,"HIGH")