Count if with Multiple Columns
Hi, This might be a simple question but I've been a little stumped by what syntax to use and hoping you can help. I have one column (Test Case Type) that has 3 options to pick from 'Original', 'E2E', or 'PAT'. I have Another column 'IC Review Status' where the drop-down options are 'Not Started', 'In Progress', or 'Completed'. Through Sheet summary I"m able to use a Count If statement to determine the count of each type per that column but not able to figure out how to get a count of only E2E with how many are 'Not Started', 'In Progress', or 'Completed'. I tried to combine my individual 'Count if' statements and am getting a #Unparseable Error.
=COUNTIF(([Test Case Type]:[Test Case Type], "E2E"), ([IC Review Status]:[IC Review Status], "In Progress"))
Any suggestions would be appreciated as I've been trying different syntax to make it work with no luck but am guessing it's something pretty simple and I'm just missing it. Thanks in Advance!
Answers
-
I am still trying to figure out how to use all the formulas, but try this.
=COUNTIFS(Test Case Type:Test Case Type, "E2E", IC Review Status:IC Review Status, "In Progress")
-
Hi Stephanie, thanks for the input but sadly I'm still getting the '#Unparseable Error'. I'll keep trying but I appreciate your response!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!