+ Reply to Thread
Results 1 to 2 of 2

Sum IF based on > than

  1. #1
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    Office 365
    Posts
    471

    Sum IF based on > than

    Hello



    IN H2 = if G1 is greater than 1, Sum D,E,F,G (can this be done in one formula)

    Please see attahed example:


    paul
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2019 H: 365
    Posts
    940

    Re: Sum IF based on > than

    Hi Paul,

    Pop this in cell H2 and copy it down.

    =IF(G2>1,SUM(D2:G2),0)

    NB - Based on your expected results I've assumed that you mean the relevant row in column G is greater than 1 rather than cell G1 explicitly.

    I hope this helps? If you have any queries or need it tweaking just give me a shout.

    Regards,

    Snook

+ 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. Replies: 2
    Last Post: 09-02-2018, 01:09 PM
  2. Replies: 5
    Last Post: 06-08-2018, 11:15 AM
  3. conditional formatting fill cells based on text, how to find sum based on CF colour
    By tubbybear in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-27-2016, 12:04 PM
  4. Replies: 4
    Last Post: 05-19-2015, 11:53 PM
  5. [SOLVED] using SUMIFS and adding values based on multiple criteria based on selection from the drop
    By muheebrahman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-25-2015, 12:55 AM
  6. [SOLVED] Highlight cell based on total quantity value based on repeated order numbers
    By PWilson0727 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-29-2014, 02:02 PM
  7. Replies: 9
    Last Post: 04-18-2013, 09:27 AM

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