I have a spreadsheet with a column that has a dropdown list in each row to assign a project to a person’s name. (each row is a new project) I need a formula to calculate how many projects each person is assigned. 

​I have a spreadsheet with a column that has a dropdown list in each row to assign a project to a person’s name. (each row is a new project) I need a formula to calculate how many projects each person is assigned.   Read More

​