Hi,

We really don't have enough info here to answer this - show us a sample of
the data.

You might just use SUMIF(MonthsRange,Month,SumRange)
--
Cheers,
Shane Devenshire
Microsoft Excel MVP

"Wiggy" wrote:

Hi,
Is there a formula for compiling monthly figures from a sheet with differant
months in it, rather than having to manually sort them?