Using SUMIF

I have a table (see attachment) of sales of several products in columns by week and by month in rows. This is a sub set of a Pivot Table
I need a grand total at the bottom achieved by totaling the months. The month totals are identified in a column as Month name followed by "Total"

I had thought to achieve my aim by using SUMIF as follows
=SUMIF($F:$F,"RIGHT(****,5)="Total" ",H:H)

Wher Col F contains the month names and col H the sales to be summed
My problem is what to put in as ****. I Have tried RIGHT(F:F,5) but this does not work.

Can anyone help me please
John