Using SUMIF with dates


I am tying to sum cells within a column that are greater than a specific date. Unfortunately, the current formula I am using isn't adding any of the cells that meet the date criteria. It only returns 0. Where did I go wrong?

This is the formula I am using:

=SUMIF([Order Date]:[Order Date], AND(@cell >= 2021, 1, 1, [PO Total]:[PO Total]))

Thanks in advance,

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!