Totaling a group of rows by the name of the person

Hello,

I at one point in time actually did this. It may have been with someone's help here. I don't remember.

What I am trying to do for several sheets is I will have a list of a person and project they are assigned -- Mike -- Project A, etc. I would like to the right a total for all the users and a count of the projects they are assigned:
The spreadsheets were created already with the cell containing the person's name and project separated by " -- ". I can't change the sheet to have a Name column and a Project column.

excel.JPG


Can what I want to do actually be done?

Thank you,
Mike

Originally Posted by Tony Valko

This formula entered in D2 and copied down:

=COUNTIF(A:A,C2&"*")

The people are not static. Meaning they could change. Could the CountIf somehow go through Col A and determine who the people are with the projects? For example, for different departments, Person A and Person B might be assigned to projects. However, in a different department, there could be 5 people.

Thank you for the quick response.

Basically, I am looking for a Pivot Table that will use the values of the Project column up to the " -- " (the names of the person)

Thank you