Wild card in two condition text formula

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

Guest

I am using the following formula to count text that have two conditions
1) Column A is not blank
2) Column D contains a particular word

=sumproduct(--(A1:A400<>""),--(D1:D400="*A.A.A.*")). I am getting a value
error. Column D may or may not contain text that has A.A.A. in it somewhere.
Any thoughts?
 
=sumproduct(--(A1:A400<>""),--isnumber(search("A.A.A",D1:D400)))

=search() doesn't care about upper/lower case
=find() is case sensitive
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two Condition Vlookup 1
wild card -- help with formula 10
IF(AND condition 1
Average with multiple conditions 4
Referencing Database tables with excel functions 9
Conditional Formating Formula? 5
Using Sumproduct - Excel 2003 3
Conditional sum - Two dimensional (advanced) 3

Back
Top