Using Sumifs and Month referencing another sheet

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

Hello!

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

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!