Wildcard and Sumproduct

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=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)
 
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
 
David,

I am an FF user, and that is so helpful ... thanks a ton.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Thanks Bob for feedback, [Google Groups hard to use]
I've rearranged that section a bit to separate format of Google
Groups result from the bookmarklet ("gg:fix") that only works in Firefox.
http://www.mvps.org/dmcritchie/firefox/search.htm#ggorientation
and copied the first part to my Excel newsgroups page
http://www.mvps.org/dmcritchie/excel/xlnews.htm#ggorientation

I tried to see if there was a comparable bookmarklet for IE7
but didn't see anything. The bookmarklet definitely would not
work in IE6.

"Bob Phillips" wrote
 
Back
Top