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!