Hi Bob,

Many thanks for your ongoing support.

As you can see it has been more than a few days since my last reply (I took
paternity leave and a few weeks holiday from work)....

Anyway, I've now array entered the formula and it still doesn't appear to
want to work for me. It is quite happy assuming the month is entered,
January, February etc but as soon as i use the Yearly Total option or remove
the month i get the #VALUE! error.

Any suggestions?

Many Thanks,