Using Sumifs and Month referencing another sheet

Angela Cisneros

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

David Tutwiler

Are you using the Date column type in the range {Summary Roll-up - Delivery End}?

David Tutwiler

Are you using the Date column type in the range {Summary Roll-up - Delivery End}?

Angela Cisneros

Wow! That fixed it. Thanks for the tip!

David Tutwiler

No problem. Glad it's working.