Formula For Sum of Spend Per Month During a Start and End Date

Hello All,

Many Thanks for looking at this problem!

Well, I have a database of spend per month using a sumif function. What I need is a formula that sums up the total spend between 2 dates and anything before or after these dates are not included in the total spend.

So for instance, a person spends 100 pounds a month for 24 months between dates 01/01/11 - 01/01/13. But I need a formula to work out what the person spent between dates 04/09/11 - 04/07/12. This is needed for over 5000 lines of data.

I hope iv explained that ok. Iv attached an example as well.

Many Thanks

Darren

here you go!

Thanks so much guys!

Benishiryo - Yes they are supposed to include those months.

How would i change that formula to include only certain cells. For example iv attached another spreadsheet which is similar to the one above but iv added two coloums to each month. But I only want to include the invoice total for that month.

On the attached spreadsheet, the amount under invoice total for each month is what i want to look at. That forumla by RCM is great but tis there a way to change to just accept them cells?

I hope you understaned.

Many Thanks

Darren

Thanks Kevin!! That Works perfectly!

When I drag down that formula down for different data, the formula does not change. Am I doing something wrong?
So in the above example, for person 2, person 3 etc.


Cheers
Darren

Cheers Guys! All Sorted.

Thanks
Darren