=SUMPRODUCT(--(A1:20=1),--(B1:B20="A Company"),--(LEFT(C1:C20,2)="46"))

but haven't you asked this and gotten an answer before?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"kd" wrote in message
...
I have to fulfill three conditions from the three coloumns below
1st Pick 1's from Column A
2nd Pick A Company from Column B and
3rd Pick all starting from 46

Column A Column B Column C
0 A Company 46401000CC
1 B Company 46406500DC
0 C Company 54010000PO
1 A Company 46046544EJ
0 A Company 46330578LT
1 A Company 46301456DD

Any help getting the formula with that would be greatly appreciated.

Thanks in advance.
KD