COUNTIF with multiple criteria, referencing another sheet
I am trying to use a COUNTIF formula that will allow me to count the number of status items (status column) linked the Helen (name column) that are marked as complete. Essentially, I want to be able to count how many status items Helen has completed.
Can someone assist with this forumla? Each time I try, I get a parsing error.
Answers
-
=COUNTIFS(Name:Name, "Helen", Status:Status, "Complete")
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
-
In my answer, you would want to match the "Helen" to the full value that you have in that cell, as I believe that you marked out Helen's last name. This formula will also include any new values that are added for helen, when they are marked complete.
Smartsheet Community Champion and Ambassador
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
