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
Bookmarks