SUMPRODUCT Question

K

Karen Smith

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)
 
R

RagDyeR

Exactly what does "Not Working" mean?

Your formula looks fine!
--

Regards,

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

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)
 
S

Sandy Mann

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
S

Stephen

Did you copy this formula from your spreadsheet or retype it into your post?
If you copied, there is an extra "!" after "Be" in the first condition. But
I also notice that the later range references are in lower case, which leads
me to suspect you retyped, in which case we are not necessarily seeing your
formula exactly as you have it.

What do you mean by "not working"? Do you get an error value, or a number
that is different from what you expect? What is the data in C9 (text or
number) and does this match the data in A3:A99? Similarly for E7 and D3:D99.
Post back with more information.
 
D

David Biddulph

You may wish to think about one vital characteristic of parenthseses in a
formula.
 
S

Sandy Mann

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top