Conditional SUMIF???

daveo61 · #1 (**permalink**) 11-11-05, 04:59

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.

daveo61 · #2 (**permalink**) 11-11-05, 08:55

After much searchong a load of hassle I found out how to do this.

Attached is the formula for the info of others ...

Code:

=SUMPRODUCT(--('[Home Inbound1.xls]Survey MAILINGS 2002-05'!$A$8:$A$10000>=VLOOKUP(B1,Sheet1!A:B,2,FALSE)), --('[Home Inbound1.xls]Survey MAILINGS 2002-05'!$A$8:$A$10000<=B1), '[Home Inbound1.xls]Survey MAILINGS 2002-05'!$P$8:$P$10000)

Internet Services

Web Development

Digital Marketing

Consumer Tech