+ Reply to Thread
Results 1 to 4 of 4

Auto sum growing range base on dates

  1. #1
    Registered User
    Join Date
    09-12-2018
    Location
    Edmonton Canada
    MS-Off Ver
    365
    Posts
    2

    Auto sum growing range base on dates

    Hi
    I am working with a Paystub and would like to know what Formula I should be using to Have my YTD update automatically each payperiod. Currently I calculate and add it manually.

    Example: Regular Pay 100.00 YTD 150
    vacation Pay 50.00
    Total pay 150.00


    Regular pay 75.00 YTD 250.00 ( would like to have this calculate each pay period)
    vac Pay 25.00
    Total Pay 100.00


    As in the attachment I would like when E3 is changed each payperiod that k13 automatically updates
    Attached Files Attached Files
    Last edited by Brendamom32; 09-12-2018 at 08:44 PM. Reason: made mistake

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Formulas

    title updated....
    Last edited by protonLeah; 09-12-2018 at 08:10 PM.
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    09-12-2018
    Location
    Edmonton Canada
    MS-Off Ver
    365
    Posts
    2

    Re: Formulas

    I will fix
    Last edited by Brendamom32; 09-12-2018 at 08:01 PM.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,425

    Re: Auto sum growing range base on dates

    Using formulas, I don't know of a way to have K13 (in the file attached to post #1) add to it's previous value when E3 changes. However, you might want to look at the Bonus Pay Stub Template 02 from this site which may be modifiable to meet your needs.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Copy Formulas from 'Formulas' Sheet into Data Table Columns
    By Jonny757 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-10-2020, 08:18 PM
  2. Replies: 9
    Last Post: 12-04-2015, 05:19 PM
  3. Poll on - Lots of simple formulas vs fewer but more complex formulas
    By gassiusmax in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-20-2014, 08:51 PM
  4. [SOLVED] Need Formulas to Hide Partial Concatenate Data and Help Determining Two Other Formulas
    By Mattdim805 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-13-2013, 04:11 PM
  5. Using Cell references in file paths for formulas to create dynamic formulas
    By MichaelStokesJr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2013, 11:49 AM
  6. Replies: 5
    Last Post: 09-25-2013, 02:51 PM
  7. Replies: 5
    Last Post: 05-05-2008, 02:22 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