Using SUMIF

[j_Southern]

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

[NBVC]

How about just?

=SUMIF($F:$F,"*Total",H:H)

[canapone]

Hi,

you could try an array sum

Please Login or Register  to view this content.

to be confirmed with control+shift+enter.

Regards

[j_Southern]

NBVC
Thanks for that it does the trick. I was getting far to complicated.
John