Using Sumifs and Month referencing another sheet
Options
Angela Cisneros
✭✭✭
Hello!
I am trying to sum the values occuring in a particular month referencing another sheet. Here's my formula:
=SUMIFS({Summary RollUp  Machine Accepted}, {Summary RollUp  Machine Accepted}, >0, {Summary RollUp  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

Are you using the Date column type in the range {Summary Rollup  Delivery End}?
Answers

Are you using the Date column type in the range {Summary Rollup  Delivery End}?

Wow! That fixed it. Thanks for the tip!

No problem. Glad it's working.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!