Sumif question

Andre O

Ahhhh…

Still not parsing…

=COUNTIFS([Quote Status]:[Quote Status], OR(@cell = "In Progress", @cell = "Bid Submitted", @cell = "Results Pending", @cell = "On Hold") [Project Type]:[Project Type], OR(@cell = "New Construction", @cell = "Remodel", @cell = "Addition", @cell = "Hybrid") [Quote Completed]:[Quote Completed], IFERROR(YEAR(@cell), 0) = 2024, [Bid Success Probability]:[Bid Success Probability], @cell = "Ag Partner 80%")

Andre O

=COUNTIFS([Quote Status]:[Quote Status], OR(@cell = "In Progress", @cell = "Bid Submitted", @cell = "Results Pending", @cell = "On Hold") [Project Type]:[Project Type], OR(@cell = "New Construction", @cell = "Remodel", @cell = "Addition", @cell = "Hybrid") [Quote Completed]:[Quote Completed], IFERROR(YEAR(@cell), 0) = 2024, [Bid Success Probability]:[Bid Success Probability], @cell = "Ag Partner 80%")

Thought I fixed it…still getting the parsing error.

Sorry for being a pain!

Paul Newcome

Now you are just missing two commas. One after you close out each OR before you start the next range.

Andre O

Awesome! Working now!

Andre O

So, I guess that what I'm trying to do is more complex than I thought.

In that same COUNTIFS formula I also need to exclude one of the people that bids on jobs. I have a Quote Person column, and I need to exclude 1 person from that.

Would I use [Quote Person]:[Quote Person], NOT(CONTAINS(@cell = "Persons Name"),

If that is correct where do I put it in this formula?

=COUNTIFS([Quote Status]:[Quote Status], OR(@cell = "In Progress", @cell = "Bid Submitted", @cell = "Results Pending", @cell = "On Hold"), [Project Type]:[Project Type], OR(@cell = "New Construction", @cell = "Remodel", @cell = "Addition", @cell = "Hybrid"), [Quote Completed]:[Quote Completed], IFERROR(YEAR(@cell), 0) = 2024, [Bid Success Probability]:[Bid Success Probability], @cell = "Ag Relationship 40%")

Paul Newcome

You would need one more closing parenthesis after the NOT/CONTAINS. As far as where… It doesn't really matter so long as you follow the appropriate syntax for COUNTIFS of range comma criteria comma range comma criteria comma so on and so forth.