Excel Formula

Hi I am trying to create an excel formula, to count the below requirements:

It is to try and run some analysis on a risk register:

If specific text is entered in column J (Team Name), i then want to count the number of cells in column G that are also text (either, High, Medium, Low)

i would then want the answer displayed as a number, i would then use the formuls to work out other selections so i could graph it.

a further issue is this table is amended weekly so the formula would need to be based on columns so the table would amend dynamically.

be great if someone can help, and i am sure its not as compicated as i am making it sound.