Hi
This sounds like a job for Data/Pivot Table, which is a fantastic tool for
summarising data. Here's an intro:
http://www.cpearson.com/excel/pivots.htm

--
Andy.


"Redsmartie" wrote in
message ...
I have a sheet where I enter invoices raised. Can I automatically get a
formula to look at the extent of a range of dates and provide a monthly
total.

The problem is that there is going to be a different amount of entries per
month so the formula must be able to select all Jan 05, Feb 05, Mar 05
values, etc from a list.