+ Reply to Thread
Results 1 to 3 of 3

SUMIFS with blank cells

  1. #1
    Registered User
    Join Date
    02-12-2015
    Location
    South Africa
    MS-Off Ver
    10
    Posts
    31

    SUMIFS with blank cells

    Hi guys

    I had the formula working perfectly with assistance from a forum expert.
    Unfortunately I've done something to it as it's not returning the correct info.

    Can anyone assist? The cell highlighted in yellow.

    Any help is appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: SUMIFS with blank cells

    You have a Circular Reference in Cell R458 & R459 in Sheet "ASSORTMENT"
    Please Change that it will work
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    02-12-2015
    Location
    South Africa
    MS-Off Ver
    10
    Posts
    31

    Re: SUMIFS with blank cells

    Thank you for pointing this out. I've corrected this but notice the value pulling through are still not correct. Although this seems to be an unrelated error.

+ 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. [SOLVED] SUMIFS with blank cells in criteria
    By Frodoe in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-13-2015, 03:37 AM
  2. Is Error with Sumifs to return blank not 0
    By LauraWork in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-27-2013, 11:48 AM
  3. SUMIFS to sum cells if reference cells are blank...
    By roseme in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-19-2013, 02:09 PM
  4. [SOLVED] SUMIFS error with blank cells. Fix or workaround?
    By AshleyCooper in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-22-2013, 01:44 AM
  5. SUMIFS Not Blank Criteria
    By philwilliams80 in forum Excel General
    Replies: 3
    Last Post: 09-30-2011, 11: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