SUMIF statement based on dates
I would like to create a SUMIF equation to only sum data (column F) based on a date range (column . It works in excel with the following equation for reference.
=SUMIF($B$9:$B$2000, ">=9/1/2018", $F$9:$F$2000)-SUMIF($B$9:$B$2000, ">=9/30/2018", $F$9:$F$2000)
However, when I import it to smartsheets, I get an error.
My best attempt at the new equation is (also creating an error):
Could someone help me with how the equation should be formatted?