In additional to number of sales order I need to know how many each Project
Mgr has assigned to them. E.g. I need to see that
Prem 3
DeVivo 1
Sturm 1

Please help

"Elizabeth" wrote:

I have a list of records where the Project Manager has several numbers
assigned to him but sometimes the number is duplicated. How do I use the
CountIF so that it only counts the number once? Here is an example of my
data:

Sales Order Project Mgr
6100517416 Gomes
6100517416 Gomes
6100517424 Gomes
6100517424 Gomes
6100517425 Gomes
6100517425 Gomes
6100521493 DeVivo
6100531944 Sturm
6100531944 Sturm