Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Calgary, Alberta, Canada
    Posts
    818
    Thanks
    6
    Thanked 1 Time in 1 Post

    Exclamation Conditional summatioon - using SUMIF I think

    I am trying to create a total for orders placed on a specific day, so I have a named range called "Price" and another named range - "Date_ordered" and I want to create a total for orders placed on, e.g., June 13, 2011. so I create this formula:

    =SUMIF(Date_ordered,"="&DATE(2011,6,13),Price)

    I may also want to create a total for orders placed on another date, e.g., June 30, 2011.

    This does not give me the results I expected (obviously), rather it gives me a "date" as the result of the "SUMIF" operation. Can someone help me straighten this out? Thanks.

    Ron_M

  2. #2
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    The Hague, Netherlands
    Posts
    283
    Thanks
    0
    Thanked 0 Times in 0 Posts
    X2: 13-Jun-11

    Y2:

    =SUMIF(Date_ordered,X2,Price)

    should yield a total rekated to X2.

    If you enter 30-Jun-11 in X3, the formula can be copied down to obtain the total for X3.

    Are we missing something?
    Microsoft MVP - Excel

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    I suspect it's just cell formatting if you are getting a date - Excel stores dates as numbers. Change the cell format to a number format or General and see if the result tallies with what you expect.
    Regards,
    Rory

    Microsoft MVP - Excel

Tags for this Thread

Posting Permissions

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