What function do i use to total amounts from rows with items from certain dates?

[brendongl]

Hi

I'm making a cashflow-style spreadsheed in Excel2010 on Windows 7.
I have a couple of sheets, one for summarys, daily sales, invoices, etc.

On my invoices sheet I have date,payee,reference no, subtotal, total incl. gst, etc.

I want to be able to make a function that can add the TOTAL for a certain period of time E.G per month.
I think something like a lookup function would be used here but I'm not very advanced. Any help would be great, if more information is needed please ask. thank you.

 

[T. Valko]

Ahh, this works too. Works better as well so i can be more specific than months, since my summary totals are also for weeks. thanks!

You're welcome. Thanks for the feedback!