Julie, I need to see count of sales order per project manager. I think I
must doing something wrong. I gave error message using this formula:
=SUMPRODUCT(--($A$3:$A$75=N3)/COUNTIF($D$3:$D$75,$D$3:$D$75)+($A$3:$A$75="")))

A3:A75 Sales Order range
D3:D75 Project Manager
N3 where I want the results displayed.

I think I missed something. Help.
"JulieD" wrote:

Hi Elizabeth

sorry, let's try that again ...

if you want a count per Project Manager use the following formula
=SUMPRODUCT(--($B$11:$B$19=F11)/(COUNTIF($A$11:$A$19,$A$11:$A$19)+($A$11:$A$19="") ))
where your current data is in the range A11:B19
and you have "Gomes" typed into F11

if you want an overall count of unique project numbers use the following
array formula
=SUM(1/COUNTIF(A11:A19,A11:A19))
(an array formula needs to be entered using control & shift & enter not just
enter)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Elizabeth" wrote in message
...
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