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.

Any ideas please guys??

TIA.