Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Location
    England.
    Posts
    232

    Unanswered: Conditional SUMIF??? Possibly SUMPRODUCT?

    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.
    Last edited by daveo61; 11-11-05 at 07:32.

  2. #2
    Join Date
    Feb 2005
    Location
    England.
    Posts
    232
    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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •