Getting #Invalid Operation error

Try this: =SUMIFS([Quantity Pass]:[Quantity Pass], Date:Date, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()))

=SUMIFS([Quantity Pass]:[Quantity Pass], Date:Date, AND(@cell <= TODAY(7), @cell >= TODAY()))

@Nic Larsen shouldn't that be a Today(-7)

=SUMIFS([Quantity Pass]:[Quantity Pass], Date:Date, AND(@cell <= TODAY(-7), @cell >= TODAY()))

@Mike Wilday Good catch. It's been too long of a week.

Haha. I feel ya!

:( Still getting the same error. It has to be something within the sheet itself, right? The syntax seems perfectly fine on both suggestions .

What type of column type do you have it set to? That's the only thing that comes to mind.

Formula in a text/number column type?

Date column set to a Date type of column?

https://help.smartsheet.com/articles/2476176-formula-error-messages#toc--invalid-operation

According to formula errors,

This error is due to operators.

But I am not seeing that. I also sometimes see this error when there are errors in the date column. If you have any errors in the date column you would want to wrap your Month queries in an IFERROR formula or resolve your errors in the column.

@Nic Larsen Date column is set to date type, "Quantity Pass" is a number column. Has a column formula to calculate total (=[Quantity Inspected]@row - [Quantity Fail]@row).

I'm stumped.

I created a column formula and it worked fine. Are you summarizing any data at the top/bottom of these ranges that it might be interacting with? Are both formulas getting the error or just one of them?

I updated this with an additional IFERROR as Mike mentioned above:

=SUMIFS([Quantity Pass]:[Quantity Pass], Date:Date, IFERROR(MONTH(@cell), 0) = IFERROR(MONTH(TODAY()), 0))

Yeah. I have the same formula in a different sheet with no issues. I'm totally lost.

I got the same for both the week and month formulas. Even after using the suggested formulas you all so graciously suggested. :/

If you scroll through your date column are you seeing any errors? Errors in your date column frequently throw Invalid Operation errors in SUMIFS and COUNTIFS when using them in the criteria.

I'm going to shake our data entry folks. I finally found it...instead of "0" someone had put "None" in the Quantity Pass column. UGH.

THANK YOU all!