How to count how many # per subheading?

A pretty iffy title, I'll try explain it better.
So, I have a VCE sac coming up and I need to know how to do this.

Here's a short version. (The real one continues like this till 1859)

(Temps are made up here)

Basically I need to see how many months's temperatures are over 30, per year.
I'm pretty basic at excel so this may be the easiest thing you've ever done.

I made it so when it the temp is equals or over 30, it comes up with "Over", and "under" if it isn't. =IF(C2>=30, "Over", "Under")
How can I use this to make a graph that shows how many months are over 30 per year?

(attached again below incase this one stuffs up)
Year Month Temperature
2014 1 46 Over
2014 2 37 Over
2014 3 33 Over
2014 4 27 Under
2014 5 26 Under
2014 6 24 Under
2014 7 16 Under
2014 8 17 Under
2014 9 22 Under
2014 10 26 Under
2014 11 30 Over
2014 12 33 Over
2013 1 42 Over
2013 2 36 Over
2013 3 31 Over
2013 4 30 Over
2013 5 27 Under
2013 6 26 Under
2013 7 22 Under
2013 8 17 Under
2013 9 19 Under
2013 10 22 Under
2013 11 31 Over
2013 12 34 Over


Sorry if I'm not explaining it well.
Thanks in advance.

outcome data recreatation.xlsx

Perfect, thanks heaps!
Rep'd!

Hi,

You can use for instance countifs or sumproduct:

=SUMPRODUCT(($C$2:$C$25>30)*($A$2:$A$25=H2)) or =COUNTIFS($A$2:$A$25,H2,$C$2:$C$25,">30") where H2 is Year.

Chart enclosed.

Countifs is perfect, thanks loads!
Rep'd