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")
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.
If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.
Help Article Resources
Categories
Check out the Formula Handbook template!
