Hi

are you sure you're using control & shift & enter to enter the formula and
not just enter
have you changed a1:a10 to your actual range?

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"TBoe" wrote in message
...
Thanks much for your help Julie. Really appreceite it. I keep coming up
with 0 as the total. There's probably about 15 different names. I'll
work
with that formula awile to see if it will solve this. I'm sure it's just
me.
Thanks again.

Terry

"JulieD" wrote:

Hi

you can use the following array function (enter it with control & shift &
enter, not just enter):
=SUM(1/COUNTIF(A1:A10,A1:A10))

where your data is in the range A1:A10

check out http://www.cpearson.com/excel/duplicat.htm for more options and
details

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"TBoe" wrote in message
...
I have a column with people who contacted us during a given month. Some
times the same person 2 to 3 time during the month. What funtion would
I
use
to count this list but only count duplicate names to = 1. Thank you.

1 Jim
2 stan
3 stan
4 bob
5 Jim
6 Scott

t = 4