+ Reply to Thread
Results 1 to 4 of 4

SUMIFS to sum cells if reference cells are blank...

  1. #1
    Registered User
    Join Date
    12-19-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    9

    SUMIFS to sum cells if reference cells are blank...

    Hello everyone,
    I am new to the forum and was not able to find what I was looking for in a previous post. I am trying to use the SUMIFS function to sum the cells in one column if the cells in a reference column ARE blank, and if the cells in a different reference column fall within a date range.

    -Column F contains currency, and is the sum range
    -Column H contains dates as well as blanks, and I need the criteria to look for cells that ARE blank.
    -Column A contains dates, and I need the criteria to be <= 01 Feb 2013 and > 31 Dec 2012

    This is the formula I have tried, but it keeps adding the cells in F if the cells in H ARE NOT blank. Clearly, it's an issue with "<>" and probably a very simple solution, but I just can't figure it out. Any help would be greatly appreciated!

    =SUMIFS('2013'!F9:F59,'2013'!H9:H59,"<>",'2013'!A9:A59,">"&DATE(2012,12,31),'2013'!A9:A59,"<"&DATE(2013,2,1)

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: SUMIFS to sum cells if reference cells are blank...

    try
    Please Login or Register  to view this content.

  3. #3
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: SUMIFS to sum cells if reference cells are blank...

    for blanks its not "<>" as that says does not = blank
    you use "="
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  4. #4
    Registered User
    Join Date
    12-19-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: SUMIFS to sum cells if reference cells are blank...

    Thank you so much, the "=" worked perfectly. I knew it must be an easy fix, but just got stuck...I appreciate the help!

+ 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. [ASK]VBA romove cells that are blank from reference of Sum function
    By hochoaivandot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2013, 09:05 PM
  2. [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
  3. Assign Reference Number to Blank Cells
    By BSOD14 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-05-2013, 10:48 AM
  4. Replies: 4
    Last Post: 07-15-2008, 01:42 PM
  5. [SOLVED] COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN
    By carricka in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-06-2005, 12:06 PM

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