Count If

[rmeister]

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.

 

[Don Guillett]

Have a look in the help index for COUNTIF