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)