COUNTIF to determine the occurrence of "specific text" from another sheet.
I've been able to find close approximations to what I'm looking for, but have one missing piece. I have a summary sheet ("summary") that pulls data from another source form evaluation sheet ("source"). Essentially, I have a workflow in place on the summary that when stakeholders are identified for a specific client an update request with a link to the source's form evaluation is sent.
What I would like one of the columns in the summary sheet to do is count the number of updates received for a specific client (the evaluation form is drop-down based so as the user fills out the evaluation they must choose the specific client being evaluated). While I have a good understanding of how to count for specific text, I want to be able to accomplish this with a repeatable formula that in layman terms does the following: Review the source column with the client name and as criteria search the client name indicated on the summary column and count how many times it reoccurs.
As an example, assume that there are three stakeholders identified on the source and the update request with link to the form evaluation is sent to them. Two of the stakeholders respond which is fed into the summary. As you can see, I would expect the formula in the summary to return a value of two in the "Number of Responses Received" column. As I mentioned I want it to use the summary client name column as the source of the "specific text" as I want to avoid having to manually update it for each separate client.
Help Article Resources
Check out the Formula Handbook template!