Help with formula please

I am trying to sum "Echo Specific CME" that fall between the dates of 5/1/2018 to 4/30/2021 on column "Date of CME".  I keep getting an "Unparseable" error.  Please let me know what I am doing wrong...

My formula:  =SUMIFS([Echo Specific CME]:[Echo Specific CME], [Date of CME]:[Date of CME] >=(DATE(2018, 5, 1), OR([Date of CME]:[Date of CME] <=(DATE(2021, 4, 30)))

Columns on sheet: | Date of CME | Course Name |Echo Specific CME |Vascular Specific CME |



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!