Formula to count occurances and put multiple results in same cell

Hope I explain this correctly..

I need to provide a count of occurrences for multiple items and place the results in 1 cell.
ie; #of high, medium, low occurrences for a product. where the results would be presented in single cell as 1H, 2M etc..

Attached is sample spread sheet. to provide a better example.

columns A, B, C would be the input
Columns G and H are the results and how i need to present them.

Hope this is possible..

Thanks,
Steve B

With a pivot table.

and after that collect the data in 1 cell.

With a formula in H3 copy down:
=(IF(COUNTIFS($B$3:$B$9,G3,$C$3:$C$9,"High")>0,COUNTIFS($B$3:$B$9,G3,$C$3:$C$9,"High")&"H ",""))&(IF(COUNTIFS($B$3:$B$9,G3,$C$3:$C$9,"Medium")>0,COUNTIFS($B$3:$B$9,G3,$C$3:$C$9,"Medium")&"M ",""))&(IF(COUNTIFS($B$3:$B$9,G3,$C$3:$C$9,"Low")>0,COUNTIFS($B$3:$B$9,G3,$C$3:$C$9,"Low")&"L",""))

You're welcome. We appreciate the feedback!

Thanks for marking the question solved.

It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.