Need Help with a "SumIfs" Formula

RonaldoW

=SUMIFS({Budget}, {Project Type}, {Project Intake Range 1}, =Complete).

The "Project Intake Range 1" is a column with "Not Started," "In Progress," "Complete". I want the sum if the "Project Intake Range 1" is "in Progress" or 'Not Started."

Mike TV

@RonaldoW

Hi Ronaldo. What is the reason you called on {Budget} or {Project Type} ranges? If you only want {Project Intake Range 1} that equals "in Progress" or "Not Started", this is what you can use:

=COUNTIF([Project Intake Range 1}, ="In Progress") + COUNTIF({Project Intake Range 1}, ="Not Started")

Mike TV

@RonaldoW

Hi Ronaldo. What is the reason you called on {Budget} or {Project Type} ranges? If you only want {Project Intake Range 1} that equals "in Progress" or "Not Started", this is what you can use:

=COUNTIF([Project Intake Range 1}, ="In Progress") + COUNTIF({Project Intake Range 1}, ="Not Started")