SUMIF function not working for dates

Question

Assuming I have a date range (Let's just say all of September), and a value associated with each date (I earned 200 on 9/5, 150 on 9/6, etc); how can I get the total for dates 9/15-9/30? Everywhere I look I've been told to put some variation of this formula: =SUMIF(H9:H16,">DATE(2017,9,15)",$G$9:$G16). [H being the dates, G being the values]

I've tried with the quotation marks, and without. I've tried referencing the date as DATE(), as a reference to a cell, date format, general format, nothing works. Every time, it returns 0. The only thing that ever worked was referencing to an exact date, no >< logical criteria. What am I doing wrong?

Answer 1

You need to put the DATE formula outside the quotes.

=SUMIF(H9:H16,">"&DATE(2017,9,15),G9:G16)

Answer 2

Thank you!!!!!!! I tried with the ‘&’ too, but i could never get the right combination. Thank you so much!