Have a look in the help index for COUNTIF

--
Don Guillett
SalesAid Software

"rmeister" wrote in
message ...

Hopefully I can explain this.
I have 1 column that has Sales Rep Name. Another column that has
Customer Name. I want to be able to count the number of customres that
a sales rep has in a different sheet. I don't want to have to do a
subtotal on the sheet in order to get my values. Is there a formula
that I can write in order to do this?

Thank you in advance for your help!

Randy.


--
rmeister
------------------------------------------------------------------------
rmeister's Profile:
http://www.excelforum.com/member.php...o&userid=30163
View this thread: http://www.excelforum.com/showthread...hreadid=556491