Using SUMIF with dates

Hello,


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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!