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.
Help Article Resources
Check out the Formula Handbook template!