+ Reply to Thread
Results 1 to 5 of 5

Change formulas to include additional cells as I fill them in?

  1. #1
    Registered User
    Join Date
    11-20-2013
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    8

    Question Change formulas to include additional cells as I fill them in?

    Hi there,

    This is my first post for help. Hopefully I'll get all the information in one shot for those willing to help me.
    Thanks in advance!

    I keep a spreadsheet with yearly sales data that I update each week with the new sales.

    What I do now:

    I update two of the three formulas at the bottom of the page each week to reflect and include the new week's worth of sales.
    The first formula adds up total sales (nothing needed here)
    Second formula adds up the sales from last year up to the point where the current week(this year) is and calculates the difference. (Work needed here)
    Third formula calculates the percentage difference from the current sales to the same sales up to the current week of the previous year. (Work also needed here)
    (Sorry if that is confusing.)

    I have attached a spreadsheet to show exactly what I'm attempting to do.

    I appreciate any help you can offer. Thank you.

    ExcelHelp.xlsx

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,952

    Re: Change formulas to include additional cells as I fill them in?

    If you move the totals away from the bottom of the list of values, that is, not under columns A and B, you can use something like:

    F1:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    F2:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    F3:
    Formula: copy to clipboard
    Please Login or Register  to view this content.



    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Change formulas to include additional cells as I fill them in?

    Using your posted workbook....
    Try these formulas

    Comp ($)
    Please Login or Register  to view this content.
    Comp (%)
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  4. #4
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Change formulas to include additional cells as I fill them in?

    In B58:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    In B59:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    or
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  5. #5
    Registered User
    Join Date
    11-20-2013
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    8

    Re: Change formulas to include additional cells as I fill them in?

    Thanks everyone! I will implement the help and see if I can get it going!

+ 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. Modifying an index/match forumla to include additional cells
    By trishcollins in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-13-2014, 09:49 AM
  2. Adding additional cells in IF formulas
    By JakeMann in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-20-2012, 06:59 AM
  3. Adding additional cells to cells with formulas.
    By pjfoster in forum Excel General
    Replies: 1
    Last Post: 02-21-2012, 07:29 PM
  4. Modifying VBA to include one additional worksheet?
    By jonvanwyk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-22-2010, 11:01 AM
  5. Formulas that include Blank Cells
    By Chantel1326 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-09-2008, 09:36 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