Do you have a date field, if so you can use

=SUMPRODUCT(--(TEXT(date_column,"yyyymm")<=200508),amt_column)

With SUMPRODUCT, you have to specify the cells, such as A2:A100, not a
complete column A:A.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"DaveO" wrote in message
...
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.