Try this array formula:
=SUM(1/COUNTIF(A1:A5,A1:A5))

Adjust your range to fit. Array formulas are committed with
Ctrl-Shift-Enter. Excel will put braces around the formula to confirm its
acceptance.

Regards
Fred

"SO CONFUSED" <SO wrote in message
...
I need an answer for an easy question.

In this example I have the following names

COLUM A COLUM B
FRED FLINTSTONE
BARNEY RUBBLE
DINO FLINTSTONE
WILMA FLINTSTONE
HUMPHREY BEAR

AND SO THE LIST GOES ON AND ON FOR ABOUT 200 NAMES I HAVE.

i WANT TO GET A FORMULA THAT WILL TELL ME HOW MANY PEOPLE ARE IN THIS LIST
ALL TOGETHER IN COLUM A ONLY. CAUSE IF I USE A AND B THE SAME PERSON GETS
COUNTED TWICE.