+ Reply to Thread
Results 1 to 4 of 4

Sum of 2 columns differences

  1. 05-22-2017, 07:57 AM #1
    afndst
    afndst is offline
    Registered User
    Join Date
    11-16-2015
    Location
    Lisbon, Portugal
    MS-Off Ver
    2016
    Posts
    8

    Sum of 2 columns differences

    Hello

    How can I Get de sum of the differences between the values in two columns using a one cell formula?

    Regards

    António Teixeira
    Reply With QuoteRegister To Reply
  2. 05-22-2017, 09:24 AM #2
    yurttas
    yurttas is offline
    Registered User
    Join Date
    10-28-2008
    Location
    Turkey
    Posts
    88

    Re: Sum of 2 columns differences

    .

    Example:

    This is array formula. You must enter the formula not just enter. Enter it by CTRL+SHIFT +ENTER

    =SUM(A1:A10-B1:B10)
    Reply With QuoteRegister To Reply
  3. 05-22-2017, 09:43 AM #3
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Sum of 2 columns differences

    Hello afndst and welcome to the forum,

    There are two answers in the attached. The second

    =SUMPRODUCT(ABS(A2:A5-B2:B5))

    does not need a CSE entry of the formula.

    Sum of Differences between two columns.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  4. 05-22-2017, 02:27 PM #4
    Amanda Wilso
    Amanda Wilso is offline
    Forum Contributor
    Join Date
    12-18-2016
    Location
    London
    MS-Off Ver
    Microsoft 2013
    Posts
    145

    Re: Sum of 2 columns differences

    =SUM(B1:B10) - SUM(A1:A10)
    Or
    =SUM(ABS(b1:b10 - a1:10)) CTRL+SHIFT+ENTER
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Comparing 2 columns in a row of columns and identifying differences
    By westchr5 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-14-2016, 10:44 AM
  2. Create Columns Comparing differences in Other Columns
    By mvannucci in forum Excel General
    Replies: 1
    Last Post: 08-02-2015, 07:56 PM
  3. [SOLVED] Compare data in Columns A & B - Show differences in Columns C & D
    By syncguy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2015, 09:59 PM
  4. Differences between columns
    By spartanhockey in forum Excel General
    Replies: 2
    Last Post: 01-21-2010, 04:04 PM
  5. [SOLVED] Differences between two columns.
    By Mr. Smiley in forum Excel General
    Replies: 4
    Last Post: 09-19-2005, 08:05 PM
  6. [SOLVED] Compare 2 columns to see differences
    By Bugaglugs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. [SOLVED] Compare 2 columns to see differences
    By Bugaglugs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1