+ Reply to Thread
Results 1 to 2 of 2

calculating difference of two running totals and watching it in another cell

  1. #1
    Registered User
    Join Date
    06-18-2017
    Location
    Kolkata, India
    MS-Off Ver
    2013
    Posts
    3

    calculating difference of two running totals and watching it in another cell

    How do I calculate the difference between two 'running total' quantities and output it in another cell?
    The running totals get updated every time, and their cell addresses/locations also change. So, how do I do it?

  2. #2
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: calculating difference of two running totals and watching it in another cell

    If you do =[first_cell]-[second_cell] then the cell addresses in the formula should update automatically when the cells move.

+ 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. Running Totals - adding the difference
    By DaveDuncan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2015, 03:18 AM
  2. [SOLVED] running totals in Pivot Table - removing a user from the totals for the current week
    By eisenbergg in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 09-08-2013, 04:39 PM
  3. Difference between running totals
    By bergjes in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 01-09-2013, 01:13 PM
  4. Calculating a running difference then returning last non-negative date
    By emdee in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-04-2013, 08:39 PM
  5. Running Totals Calculating Overtime?
    By WraithMistress in forum Excel General
    Replies: 2
    Last Post: 11-02-2011, 08:56 PM
  6. [SOLVED] [SOLVED] Try to find the difference by percentage between 2 cell totals
    By chedd via OfficeKB.com in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-08-2006, 09:20 AM
  7. [SOLVED] Calculating difference on Pivot Table Totals
    By PSM in forum Excel General
    Replies: 0
    Last Post: 01-12-2006, 11:40 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