How do I use the SUMIF formula using data from another sheet to add the results within a date range?


My formula is below and is returning "INCORRECT ARGUMENT".

=SUMIF({Weekly Production Orders Range 2}, AND(ISBLANK(@cell) = false, AND(@cell >= DATE(2020, 1, 12), @cell <= DATE(2020, 1, 18))), [Week 1]2:[Week 1]10)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!