Results 1 to 5 of 5

Sumifs and return value only if greater than Zero

Threaded View

shameus Sumifs and return value only... 12-26-2014, 12:28 PM
bebo021999 Re: Sumifs and return value... 12-26-2014, 12:37 PM
shameus Re: Sumifs and return value... 01-06-2015, 11:54 AM
BadlySpelledBuoy Re: Sumifs and return value... 12-26-2014, 12:45 PM
JieJenn Re: Sumifs and return value... 12-26-2014, 12:47 PM
  1. #1
    Registered User
    Join Date
    12-04-2013
    Location
    nashville, tn
    MS-Off Ver
    Excel 2010
    Posts
    23

    Sumifs and return value only if greater than Zero

    Hope you can help!
    On the attached doc, on the summary tab in d13 I have a functioning formula. I'd like to add a criteria that tells it to only return the value if it is greater than zero. If it is NOT greater than zero, I'd like to just have a blank cell.

    Any help would be greatly appreciated.
    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. [SOLVED] SUMIFS greater than or equal
    By telton in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-11-2013, 04:55 AM
  2. Sumifs Criteria, less than, greater than
    By telton in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2013, 10:27 AM
  3. [SOLVED] Sumifs() with a greater/less than criteria?
    By bauerbach in forum Excel General
    Replies: 3
    Last Post: 06-14-2012, 01:58 PM
  4. SUMIFS and return text?
    By ZeroGravity in forum Excel General
    Replies: 0
    Last Post: 12-13-2011, 11:35 AM
  5. SUMIFS Between dates that are greater than zero
    By stevencjones in forum Excel General
    Replies: 2
    Last Post: 12-31-2008, 10:50 AM

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