Wildcard and Sumproduct
Thanks Bob,
Not before, but because, I got logged off immediately after posting this
question, I thought maybe this one has not got posted, so I posted another
after this one.
I will appologise from the group for reposting and tell them that I got
response.
Thanks again.
kd
"Bob Phillips" wrote:
=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
|