+ Reply to Thread
Results 1 to 6 of 6

Excel 2007 : SUMIFS problem

  1. #1
    Registered User
    Join Date
    05-17-2011
    Location
    Gävle, Sweden
    MS-Off Ver
    Excel 2007
    Posts
    4

    SUMIFS problem

    ok, here is the problem.

    In col A I have numbers (the number of articles)
    In col B I have arrival date of the article
    In col C I have a string which has 2 different alternatives.

    I need to sum up the numbers in col A by a certain month and year, as well as differ the two strings. I have been turning my brains inside out and so far my best idea is something like:

    SUMIFS(A1:A10;B1:B10;"MONTH=1";B1:B10;"YEAR=2010";C1:C10;"string")

    I know I am not using the MONTH and YEAR functions in a correct way, but does anyone have a better idea on how to solve this?

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,325

    Re: SUMIFS problem

    Hi and welcome to the board

    At first glance, a Pivot Table might be what you need

  3. #3
    Registered User
    Join Date
    05-17-2011
    Location
    Gävle, Sweden
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: SUMIFS problem

    Will that work even when the data really covers columns up to AC?

  4. #4
    Registered User
    Join Date
    05-17-2011
    Location
    Gävle, Sweden
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: SUMIFS problem

    Thank you for the help, but there seems to be a problem using pivot tables.

    The dates are specified by the day, and there can be several posts for the same day. Any tips on how to exclude the specific date and focus on year and month?

  5. #5
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,325

    Re: SUMIFS problem

    Could you please post a small sample of your data, with BEFORE and AFTER ? Thx

  6. #6
    Registered User
    Join Date
    05-17-2011
    Location
    Gävle, Sweden
    MS-Off Ver
    Excel 2007
    Posts
    4

    [SOLVED] SUMIFS problem

    I'm not too sure my employer would like me to post classified data online =)

    But i managed to solve the problem using:

    SUMIFS(A1:A10;B1:B10;">=2010-01-01";B1:B10;"<2010-02-01";C1:C10;"string")

    The only problem was that I had to edit each month manually, but not too much work

    Thanks anyway.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1