Results 1 to 6 of 6

SUMIFS: If no criteria match, leave cell blank, else return value

Threaded View

  1. #4
    Registered User
    Join Date
    03-26-2013
    Location
    Kansas City
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: SUMIFS: If no criteria match, leave cell blank, else return value

    Here is a potentially easier solution, where everything in [] gets replaced by your specific ranges and criteria cell names:

    =IF(COUNTIF([criteria range], [criteria])>0, SUMIFS([sum range], [criteria range], [criteria]), "")

    example: =IF(COUNTIF(H:H, A2)>0, SUMIFS(I:I, H:H, A2), "")

    This will give you back a blank whenever there isn't a data match to sum, and will help you avoid false zeros.

    The logic here is IF count finds at least one match, THEN add up the items with a match, ELSE return a blank.
    Last edited by KCchristoph; 03-26-2013 at 12:52 PM.

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