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
|