Hi everyone,
I am currently working on a spreadsheet involving a list of dates, each with
an assigned value. My wish is to add together the values for EACH MONTH,
rather than the entire list, spanning a year. This needs to be some kind of
function as dates can be added at any point and values can be retrospectively
changed. Due to the nature of the spreadsheet I cannot reorder the rows in
ascending date order. A colleague suggested that the way forward may be a
PivotTable opened in a different sheet, this would be perfect but I can't
work out how to pick up data for each month separately! It sounds like there
might be a simple solution and I'm certainly hoping there is!
Thanks for any feedback
Jenni