+ Reply to Thread
Results 1 to 4 of 4

Trying to use Subtotal to find difference between two lines of data

  1. #1
    Registered User
    Join Date
    01-10-2018
    Location
    New Hampshire
    MS-Off Ver
    2007
    Posts
    19

    Trying to use Subtotal to find difference between two lines of data

    I have about 200+ lines of data and for each third line, I would like a particular cell to represent the difference between the two cells of data directly above (I would like to do this for three separate columns). I thought using the Subtotal function might work but it doesn't appear to offer a subtraction/difference option. Is that correct? Does anyone have any other suggestions? Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365
    Posts
    10,524

    Re: Trying to use Subtotal to find difference between two lines of data

    Once the Subtotal feature has applied the SUBTOTAL function in the summary lines ... with the table selected ... hit the F5 function key > click Special ... > click Formulas > hit Enter.

    The summary rows are selected tab until you are at E4 and replace the SUBTOTAL formula with E3-E2 and while holding down just Ctrl hit Enter. The formula will populate the entire selected range.

    Did this help?
    Dave

  3. #3
    Registered User
    Join Date
    01-10-2018
    Location
    New Hampshire
    MS-Off Ver
    2007
    Posts
    19

    Re: Trying to use Subtotal to find difference between two lines of data

    That worked great - thank you! I've used the F5 for blanks but didn't think to use it for formulas!

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365
    Posts
    10,524

    Re: Trying to use Subtotal to find difference between two lines of data

    Your are welcome. Glad to help. Thank you for the feedback, rep and marking your thread Solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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