It's a bit of a brief description, but if your data is arranged well. (One
invoice per line with date in recognisable format) you could use a pivot
table and 'group' the data by month

Check out Pivot Table in help and if you need more guidance, post back

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"magspc" wrote in message
...
Have list of invoices organized by date and trying to summarize total
revenue
by a month on a summary sheet.