Can conditional sum use wildcards in the formula?

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

Guest

{=SUM(IF(Awhinatia!$A$2:$A$32="Left",IF(Awhinatia!$D$2:$D$32="Registered
Nurse*",Awhinatia!$E$2:$E$32,0),0))}


Can conditional sum use wildcards like at the end of nurse in the above
formula - If it can have I got the syntax wrong cause it won't accept it
unless the test criteria is exact
 
Hi!

Try this instead. Normally entered:

=SUMPRODUCT(--(Awhinatia!A2:A32="left"),--(ISNUMBER(SEARCH("registered
nurse",Awhinatia!D2:D32))),Awhinatia!E2:E32)

Biff
 
Chris,

You should be able to replace that with the use of the instr (VBA) or find
function (Excel)...
 
You must log in or register to reply here.

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

How can I use the * wildcard in an array formula 4
Excel Wildcard in Excel array formula 0
Can Conditional Sum use wildcards? 1
How do I count two conditions using a wildcard? 2
Sum with multiple conditions and wildcard 2
Wildcard for Conditional Sum Wizard statement. 3
Can I use wildcard characters in array formulas 1
how to use * wildcard in a sum(if((cond),range)) array formula 3

Back
Top