Need help in formula for counting only if a specific text is within a cell
Please see the image below.
I would like to count the number of Journal Articles but only those with the status "Accepted for publication(attach final pdf copy)". Currently, I am using this formula in my Sheet Summary - =COUNTIF([Activity Type]:[Activity Type], "Journal Article"). But it is also counting the Journal article with the status "Work in progress" and Planned/Not started".
Please help me guide and build a formula.
Help Article Resources
Check out the Formula Handbook template!