Can conditional sum use wildcards in the formula?

C

Chris

{=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
 
B

Biff

Hi!

Try this instead. Normally entered:

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

Biff
 
G

galimi

Chris,

You should be able to replace that with the use of the instr (VBA) or find
function (Excel)...
 
Top