I'm attempting to do a SUMIFS statement where I sum the values of the 'J' column, but only if the date in the 'D' column falls on or after a specified date. In the below, the string ?????? should basically be saying "if the date in the D column is on or after 5/30/2011".
=SUMIFS($J$2:$J$19,$D$2:$D$19??????)
I tried doing it like this but (as I expected) it did not work:
=SUMIFS($J$2:$J$19,$D$2:$D$19>=”5/30/2011”)
Thanks!
Bookmarks