Hi, I have a worksheet where data is imported from an Access Database.

Column A contains the month and year on mmm-yy format and is in descending
order i.e. latest month is always at the top.

Column B contains a number

There is about 10 years worth of data.

I need to arrive at a way where I see can instantly the sum of column B for
any year's data. Added to the problem that it has to match the Academic
Year which for us starts in August and ends the following July

Is this possible? And if so can someone point me in the right direct on
going about this.

Many thanks

A