Search and count?

Hello,

Using Excel and trying to count and display results for Column A (let's say it has test grades A, B, C, or D for each person) but I need this based on Column H's value (ie- I only want a count of the grade if the text string "Junior" is in Column H of that row). Is there a way to do this using only functions available in Excel? Using coding is out, as I could use it on my machine, but others would be blocked due to security settings. :) Thanks for any advice.