+ Reply to Thread
Results 1 to 4 of 4

SUMIFS - Sales value only for x product in 2015

  1. #1
    Registered User
    Join Date
    02-19-2013
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    71

    SUMIFS - Sales value only for x product in 2015

    Hi Friends,

    Please help me to short it out this issue.

    Sales Date Product Amount
    1/4/2014 Pen 500
    1/1/2015 Pencil 1500
    3/1/2015 Pencil 3000

    I don't want to create pivot.

    I want total sales of pencil in 2015. I tried SUMIFS function, but I couldn't find a solution.

    Answer should be........
    Pencil 2015 4500

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: SUMIFS - Sales value only for x product in 2015

    Try this =SUMIFS(C:C,A:A,">=01/01/2015",A:A,"<=31/12/2015",B:B,"=Pencil")

    Depending on Sri Lanka's date system, you may need:

    =SUMIFS(C:C,A:A,">=01/01/2015",A:A,"<=12/31/2015",B:B,"=Pencil")
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    02-19-2013
    Location
    Sri Lanka
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    71

    Re: SUMIFS - Sales value only for x product in 2015

    Oh my god!!!!

    Thank you so much for your quick reply. Thanks a lot Glenn Kennedy

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,893

    Re: SUMIFS - Sales value only for x product in 2015

    Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. sumifs with left / sum product
    By papasmurfuo9 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-30-2014, 11:39 AM
  2. Replies: 1
    Last Post: 05-31-2014, 01:38 AM
  3. [SOLVED] Sales winners by product type
    By makinmomb in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-10-2014, 10:02 AM
  4. Should I use Sumifs or Sum product.
    By jeci80 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-26-2014, 11:05 PM
  5. Product Sales to Month Sales
    By pelamis22 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-23-2013, 06:13 PM
  6. [SOLVED] SUMIFS to total product A and B
    By Subject_Name_Here in forum Excel General
    Replies: 5
    Last Post: 05-26-2012, 11:56 AM
  7. chart for product sales
    By metalgearslug in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-26-2010, 09:39 PM

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