Results 1 to 8 of 8

Higher values in Col A than Col B, sum rows with the higher value and show difference

Threaded View

  1. #1
    Registered User
    Join Date
    10-01-2020
    Location
    London, England
    MS-Off Ver
    365
    Posts
    78

    Higher values in Col A than Col B, sum rows with the higher value and show difference

    Hi Community,

    I have two columns of values, I need to know the sum of all the rows where Column A has a higher value than Column B.
    If Column B is higher then ignore.
    There could be 100+ rows of values and I need to apply this to multiple workbooks, but each workbook will have it's own total.

    Any help is appreciated.
    Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 15
    Last Post: 12-18-2020, 05:47 AM
  2. Replies: 4
    Last Post: 07-02-2018, 12:52 PM
  3. [SOLVED] Chart - Only show data of higher than zero
    By Jacolene in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-11-2017, 06:47 AM
  4. how to show only labels with values higher than 0
    By vito1 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-15-2015, 08:51 AM
  5. [SOLVED] Allocate a minimum value to a data set and absorb the difference to higher values
    By nalaka in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-28-2012, 01:01 PM
  6. Replies: 3
    Last Post: 09-14-2010, 07:25 AM
  7. Replies: 2
    Last Post: 05-31-2010, 03:23 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