I have a sheet with a lot of data in it. It tracks the effectiveness of certain campaigns we have. One of the key fields in here is Month.
What I'm trying to do is summarise the data for a board report. I have a drop down of all of the months there are in the report. If I want to do a particaular month's figures, I use a SUMIF and it gets the data fine. But if I want to do a Year to date figure, how can I do this?
ie. I have all 2004 data. If I picked Aug-04 as a month to look at I'd want to see Jan-04 to Aug-04 inclusive for my Year to Date figures and not also include Sept-04 onwards.