formula for sum of cells by month

[exodus125]

I have a data range for invoices and need to total all the invoices by month. So the heading on the data are invoice #, description, Date, amount.

I need to take all the amounts in the month of november and get a total, and so on for all the months in the year. I only need a total amount for the month, but if theres a way to generate a list for all the months enteries that woudl be great too. I think a simple sumif may be possible, but cant think of a way to write out a sum if that would work.

Thanks in advance,
Esteban

[arthurbr]

Hi
you posted in a MSWord forum, is that correct?

In XL you could use a Pivot Table f.i.

[exodus125]

sorry about that, can a mod move this to the correct section please.

[arthurbr]

Thread moved
Have you tried using a Pivot Table and grouping by month ?
( there are other possibilities - best to post a sample sheet)