Sumifs Multiple Criteria

ginamt3

I have this formula that i'm currently using. I need to add some more criteria to the formula and need some help.

current formula

=SUMIFS({MASTER SCHEDULE Range 1}, {MASTER SCHEDULE Range 2}, "Marc Holbrook", {MASTER SCHEDULE Range 3}, "DESIGN")

{MASTER SCHEDULE Range 3}, "DESIGN") and I need "AGREEMENT"

Also the first column it needs to be unchecked

Paul Newcome

For evaluating a checkbox to be unchecked, it would look like this...

........., {Range}, @cell <> 1, ...........

Paul Newcome

Happy to help. 👍️

Paul Newcome

Are you able to provide more details as to what you need?

When you say you need "AGREEMENT"... What do you mean? Is that something in a range you already have built? If so, would it be agreement OR something else?

ginamt3

AGREEMENT is an additional status I'm looking for.

I need a sum for each designer where Status is DESIGN and AGREEMENT and Hide Retained Job is unchecked

Paul Newcome

Is it "Design" and "Agreement" both at the same time as part of a multi-selection process, or would it be one or the other in a single cell?

ginamt3

one or the other in a single cell

Paul Newcome

In that case you would use an OR statement like so:

=SUMIFS({MASTER SCHEDULE Range 1}, {MASTER SCHEDULE Range 2}, "Marc Holbrook", {MASTER SCHEDULE Range 3}, OR(@cell = "DESIGN", @cell = "AGREEMENT"))

ginamt3

Thank you. This works in getting me a total for Design and Agreement for each designer.

I still need to only include the first column of unchecked "Hide Retained Job"

Screenshot 2023-12-28 at 3.04.43 PM.png

Paul Newcome

For evaluating a checkbox to be unchecked, it would look like this...

........., {Range}, @cell <> 1, ...........

ginamt3

That worked! thank you so much for your help.

Paul Newcome

Happy to help. 👍️