COUNTIFS and with 2 different values in same column with a value in another column?
I have two different columns lets say "Colone" and "Coltwo". Colone has a value GZ22 and GZ21. Coltwo column has two activities "Completed" and "Just Completed"
I'm trying to create a formula to count which counts the activity "Completed " that are done in GZ22 with the activity "Just Completed" that are done in GZ22. and both columns "Colone" and "Coltwo" are in a same sheet named CP.
i am using the formula
=COUNTIFS({CP Colone}, "GZ22", {CP Coltwo}, "Completed"})+ =COUNTIFS({CP Colone}, "GZ22", {CP Coltwo}, "Just Completed")
i get "unparseable" as the answer.
Can anyone help me solve this?
Thanks!
Best Answer
-
You need to take out the "=" in the second part of the formula.
Try =COUNTIFS({CP Colone}, "GZ22", {CP Coltwo}, "Completed"})+ COUNTIFS({CP Colone}, "GZ22", {CP Coltwo}, "Just Completed")
Answers
-
You need to take out the "=" in the second part of the formula.
Try =COUNTIFS({CP Colone}, "GZ22", {CP Coltwo}, "Completed"})+ COUNTIFS({CP Colone}, "GZ22", {CP Coltwo}, "Just Completed")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!