Is my SUMIFS formatted improperly?

Jason Malgren

I'm looking to sum $ column when Status column is "Contracted" and when Job Type column is either "Balcony" OR "Roof Anchor"

This is what I have:

=SUMIFS([$]:[$], Status:Status, "Bidding", [Job Type]:[Job Type], OR(@cell = "Roof Anchor", @cell = "Balcony"))

The result is: #INVALID OPERATION

I feel I'm probably missing something simple, but it seems to match the examples I have seen elsewhere.

Thank you.

Jason Malgren

Disregard this question, the formatting was fine, I had an invalid value in one of the columns which was throwing an error in the equation.

Genevieve P.

Hi @Jason Malgren

I'm glad you were able to sort this out! Thanks for posting your solution.