Are the SUMIFS formulas working properly?

Khoyt1

This formula worked yesterday in my sheet summary field and today is not working..

=SUMIFS([Remaining Work]:[Remaining Work], Category:Category, OR(@cell = "FC Support", @cell = "Maintenance & Reliability", @cell = "HR", @cell = "Chewy Leadership Academy", @cell = "FC Operations", @cell = "FC Systems", @cell = "Supply Chain", @cell = "Transportation", @cell = "Safety", @cell = "Quality"))

Khoyt1

Thank you for the help… there was a % symbol in a column without a number associated so it broke the formula!!

heyjay

Can you share the error you are getting? All I can think of is that something not numerical was entered in Remaining Work. SUM may break when something that is not a number is entered.

Khoyt1

# Invalid Operation is the error that is returning

Khoyt1

Thank you for the help… there was a % symbol in a column without a number associated so it broke the formula!!