+ Reply to Thread
Results 1 to 5 of 5

How to total values dynamically from different columns

  1. #1
    Registered User
    Join Date
    06-19-2017
    Location
    united states
    MS-Off Ver
    2016
    Posts
    12

    Question How to total values dynamically from different columns

    Hello I am trying to find out how to sum totals that occurred on different dates without having to go through and add them up individually
    I attached a photo of what I am trying to do but I did it manually there must be a way to do this dynamically so if as more dates are added or subtracted it will still keep the correct total.

    Thanks




    excel help.jpg

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: How to total values dynamically from different columns

    For K2
    Please Login or Register  to view this content.

    Kind regards
    Leo

  3. #3
    Registered User
    Join Date
    06-19-2017
    Location
    united states
    MS-Off Ver
    2016
    Posts
    12

    Re: How to total values dynamically from different columns

    perfect thank you!

  4. #4
    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,193

    Re: How to total values dynamically from different columns

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  5. #5
    Registered User
    Join Date
    06-19-2017
    Location
    united states
    MS-Off Ver
    2016
    Posts
    12

    Re: How to total values dynamically from different columns

    I only see option to "mark this thread as unsolved"

+ 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] Dynamically Exclude Chart Columns With Zero Values
    By Oksana in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-29-2016, 07:35 PM
  2. [SOLVED] SUM the COUNT of values between dynamically specified columns and at a specified row
    By TheClaw2323 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-07-2015, 07:06 AM
  3. [SOLVED] Extract unique values from 2 columns DYNAMICALLY
    By albatr0n in forum Excel General
    Replies: 17
    Last Post: 08-28-2012, 08:42 AM
  4. Replies: 1
    Last Post: 03-13-2012, 10:55 PM
  5. Formula to calulate total values of 5 columns
    By imatthews2001 in forum Excel General
    Replies: 1
    Last Post: 08-25-2011, 10:23 PM
  6. Inserting sub-total after change in values in three columns
    By vjboaz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-16-2008, 10:40 AM
  7. Replies: 4
    Last Post: 02-05-2005, 06:06 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