SUMIF formula not working in Sheet Summary

For some reason, I am getting an #Invalid Data Type error with my formula and cannot figure out why: =SUMIF([Fiscal Year]:[Fiscal Year], "2023", [Annual Revenue]:[Annual Revenue]). The two headers in question are text/number format with the revenue column being formatted in currency as shown below.

I tried to troubleshoot it with a coworker and hers worked without any error, even though it was configured exactly the same way as mine.

I also tried switching the sum column and the criterion in the formula, but that results in an #Incorrect Argument Set error. Please let me know what I can do to correct this. I suddenly have several #invalid data type or #invalid operations in other sheet summary fields for this worksheet, so not sure what's going on.

Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!