+ Reply to Thread
Results 1 to 3 of 3

Calculating annual sales increase

  1. #1
    Registered User
    Join Date
    05-23-2019
    Location
    Westbury, Wiltshire
    MS-Off Ver
    365 Subscription
    Posts
    8

    Calculating annual sales increase

    Hi Everyone,

    I am trying to find a formula that i can use on an entire column to input the sales increase in Column T.

    This figure needs to pull from the value in Column O minus the value Column F associated with the correct client.

    As an example I have done this manually using the formula =SUM(O4-F4) for the client A2, however i need a formula that will do this automatically for all entries in column S (in the actual spreadsheet there are around 160 which will take too long manually) it needs to look for the client name in both columns B and K, then return the difference between the two in Column T, which as mentioned above will be the value of the figure in Column O minus the value of the figure in Column F.

    I hope this makes sense to someone, i am struggling to figure out which type of formula to use?

    Thanks in advance EXCEL Problem.xlsx

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,287

    Re: Calculating annual sales increase

    Try

    =SUMIF($K$3:$K$100,U3,$O$3:$O$100)-SUMIF($B$3:$B$100,$U3,$F$3:$F$100)

    column U is list of clients i,e as per column B
    Attached Files Attached Files
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Registered User
    Join Date
    05-23-2019
    Location
    Westbury, Wiltshire
    MS-Off Ver
    365 Subscription
    Posts
    8

    Re: Calculating annual sales increase

    Thanks John, that has worked a treat. Very much appreciated

+ 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] Calculating total units for a given period with an annual percentage increase
    By woofersus in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2022, 03:00 PM
  2. [SOLVED] % of sales increase/decrease depending on new 2020 sales vs 2019 sales.
    By scubakerny in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-04-2020, 08:05 PM
  3. % Increase/decrease using annual compounded annual growth rate
    By maxhecht2 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-30-2016, 04:07 PM
  4. Replies: 1
    Last Post: 05-07-2014, 06:19 PM
  5. Calculating increase/decrease in monthly sales
    By Climaxgp in forum Excel General
    Replies: 1
    Last Post: 05-10-2012, 05:21 AM
  6. Calculating monthly sales figure required to make annual turnover figure
    By CatIsoSio Sky in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-27-2010, 04:42 PM
  7. Replies: 2
    Last Post: 07-21-2010, 12:54 PM

Tags for this Thread

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