Using Sumifs and Month referencing another sheet

Angela Cisneros
Angela Cisneros ✭✭✭
edited 10/19/20 in Formulas and Functions


I am trying to sum the values occuring in a particular month referencing another sheet. Here's my formula:

=SUMIFS({Summary Roll-Up - Machine Accepted}, {Summary Roll-Up - Machine Accepted}, >0, {Summary Roll-Up - Delivery End}, MONTH(@cell) = 1)

The first part of the formula is working correctly, but when I add the date part, I get an #Incorrect Argument error.

Appreciate any help anyone can provide.

Thank you,

Angela Cisneros


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!