I have two worksheets. I'd like one to contain the [/B]total amount I've spent each year for a particular year[/B] and the second contains what I've spent the amount on, the date purchased and the actual amount spent.
I would like Worksheet 'Yrs' and Row 4 underneath each year to total the amount I've spent for that particular year. The data for this is in a 'Purchases' Worksheet and is sourced from dates with a format of 01/01/12 as an example.
In the attached workbook (Sheet Purchases) for 2012 as an example, I would like the three 'Cost' totals for the 2012 dates to be added and then displayed under the 2012 heading in the 'Yrs' sheet. Then so on for each year
I think this can be achieved by SUMPRODUCT and YEAR but I'm not sure.
I'd be grateful for any help.
Thanks.
Bookmarks