Countifs for two criteria

alexandra.richardson

Hi! I'm trying to do countifs for two different columns on a sheet, to account for how many of each Project Status type (In Progress, Backlog, Not Started, etc) there are for each Project Lead in my sheet.

I'm wanting to use this info so I can create a dashboard chart based off of the data. I tried the following, but keep getting unparseable.

=COUNTIFS({Reporting Request Tracking Range 4}, "Alex", [{Reporting Request Tracking Range 6}, "In Progress"])

Carson Penticuff

=COUNTIFS({Reporting Request Tracking Range 4}, "Alex", {Reporting Request Tracking Range 6}, "In Progress")

Carson Penticuff

=COUNTIFS({Reporting Request Tracking Range 4}, "Alex", {Reporting Request Tracking Range 6}, "In Progress")

Paul Newcome

You don't need those [Square Brackets] in there.

The help article that shows them uses them to indicate that the second range/criteria set is optional, but they should not be included in the actual formula itself.

alexandra.richardson

Amazing, thank you both!

Paul Newcome

Happy to help. 👍️