Hi,

Try this

=SUM(IF(LEFT(C1:C20,2)="ss",1,0))

It's an array so commit with Ctrl+Shift+Enter

Mike

"Stevo" wrote:

How can I recognize the first 2 letters in a cell using formulas? I want to
be able to recognize cells which contain certain initials from employees.
Example would be if C1=SS Glass, C2=AF Metal and C3=SS Paper, I need to know
that SS had 2 entries.

I am using Office 2003 w/ SP3.

Thanks,

Steve