Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Countifs for two criteria
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"])
Best Answer
-
=COUNTIFS({Reporting Request Tracking Range 4}, "Alex", {Reporting Request Tracking Range 6}, "In Progress")
Answers
-
=COUNTIFS({Reporting Request Tracking Range 4}, "Alex", {Reporting Request Tracking Range 6}, "In Progress")
-
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.
-
Amazing, thank you both!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 500 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 78 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I am trying to count the number of times "N/A" is included in a single row. I know it can been done with a single range with the below equation, but in this sheet there are some columns that want to e…
- Hello! Long time listener, first time caller — We have a weekly update dashboard that is presented on Thursdays. We'd like to have the date displayed be either the previous weeks Thursday or the curre…
- Can a JOIN function be used in a Sheet Summary to join two or more Sheet Summary Fields? I have two separate columns that I use a JOIN function for, but I'm not seeing how I can use it in Sheet Summar…
