Formula to add criteria from multiple columns from another sheet
I need to calculate how many times "Change" appears in another sheet that has the same Project ID - I want to calculate how many changes a specific project had.
I have 2 sheets: Project Plan and Craid log
Project Plan has 2 columns - "Task Name" with the word "Changes" in the line and "Description" where I need the formula
Craid log has 2 columns - "Project ID" and "Type" with dropdown options, but I only need "Change"
I need the "Description" column in the Project Plan to calculate all the "change" in the Craid log that has the same Project ID that is in the Project Plan and the Craid log.
Help Article Resources
Check out the Formula Handbook template!