So am I. I didn't notice the extra *!* that Stephen pointed out.

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"RagDyer" wrote in message
...
Damn ... I'm blind!<g
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Sandy Mann" wrote in message
...
Actually it looks to me as if there is an extra parenthesis after d3:d99
but this may just be a typo.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"RagDyeR" wrote in message
...
Exactly what does "Not Working" mean?

Your formula looks fine!
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Karen Smith" wrote in message
...
I'm trying to use this formula, but its not working, what am i doing
wrong?

=SUMPRODUCT(--('The Worker Be!'!A3:A99=C9),--('The Worker
Be'!d3:d99)=E7),'The Worker Be'!aa3:aa99)