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.
Help Article Resources
Check out the Formula Handbook template!