+ Reply to Thread
Results 1 to 8 of 8

How to Find total sales of 2015 by the given condition

  1. #1
    Registered User
    Join Date
    08-02-2018
    Location
    India
    MS-Off Ver
    office 365
    Posts
    20

    How to Find total sales of 2015 by the given condition

    Hi All,
    i want to calculate total sales amount in the year 2015 by using the condition. please check the attached workbook.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: How to Find total sales of 2015 by the given condition

    A password is needed to open your file - what is it?

    Pete

  3. #3
    Registered User
    Join Date
    08-02-2018
    Location
    India
    MS-Off Ver
    office 365
    Posts
    20

    Re: How to Find total sales of 2015 by the given condition

    sorry, password is 1234

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: How to Find total sales of 2015 by the given condition

    I would try it this way...
    =SUMIFS('Sales Data1'!$I$3:$I$52,'Sales Data1'!$C$3:$C$52,Case1!B4,'Sales Data1'!$E$3:$E$52,2015)
    key off the employee ID.

    EDIT:
    could even do it this way if all you want to do is change I3 from total sales 2015 to total sales 2016, then the formula will automatically update...
    =SUMIFS('Sales Data1'!$I$3:$I$52,'Sales Data1'!$C$3:$C$52,Case1!B4,'Sales Data1'!$E$3:$E$52,RIGHT($I$3,4))
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: How to Find total sales of 2015 by the given condition

    You can use this formula in cell I4 of the Case1 sheet:

    =SUMIFS('Sales Data1'!I:I,'Sales Data1'!C:C,B4,'Sales Data1'!E:E,2015)

    then copy down.

    Hope this helps.

    Pete

  6. #6
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: How to Find total sales of 2015 by the given condition

    Sorry, didn't notice the "salesperson" designation so instead...
    =IF(E4="salesperson",SUMIFS('Sales Data1'!$I$3:$I$52,'Sales Data1'!$C$3:$C$52,Case1!B4,'Sales Data1'!$E$3:$E$52,RIGHT($I$3,4)),"")
    OR
    =IF(E4="salesperson",SUMIFS('Sales Data1'!$I$3:$I$52,'Sales Data1'!$C$3:$C$52,Case1!B4,'Sales Data1'!$E$3:$E$52,2015),"")

    AND of course change your ranges as appropriate.
    Last edited by Sam Capricci; 02-19-2019 at 07:41 AM.

  7. #7
    Registered User
    Join Date
    08-02-2018
    Location
    India
    MS-Off Ver
    office 365
    Posts
    20

    Re: How to Find total sales of 2015 by the given condition

    Thanq All. its working. thanks for your help.

  8. #8
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: How to Find total sales of 2015 by the given condition

    You're welcome! And if that takes care of your question don't forget to mark the post as solved using the thread tools dropdown at the top of the post.

+ 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. [SOLVED] Help! Need variable daily sales targets to total monthly sales goal
    By Chronohog in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-31-2018, 02:54 PM
  2. [SOLVED] Formula to total the sales of all product with condition
    By Manish_Gupta in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-13-2017, 02:05 AM
  3. Replies: 3
    Last Post: 03-22-2016, 04:03 AM
  4. [SOLVED] SUMIFS - Sales value only for x product in 2015
    By janagan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-27-2015, 01:31 PM
  5. Replies: 1
    Last Post: 11-19-2013, 12:52 PM
  6. Need to Find 3 Column Values and Add the Total per Condition
    By stevorama in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2012, 05:37 PM
  7. Countif to find total sales
    By F6Hawk in forum Excel General
    Replies: 9
    Last Post: 01-25-2009, 03:02 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