Can conditional sum use wildcards in the formula?
 

{=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" wrote in message
...
{=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

Chris,

You should be able to replace that with the use of the instr (VBA) or find
function (Excel)...
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Chris" wrote:

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

Works like a charm - Thanks heaps

"Chris" wrote:

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