| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT Question
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) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMPRODUCT Question
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) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMPRODUCT Question
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) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMPRODUCT Question
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. "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) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMPRODUCT Question
You may wish to think about one vital characteristic of parenthseses in a
formula. -- David Biddulph "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) |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMPRODUCT Question
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT Question | Excel Worksheet Functions | |||
| question on SUMPRODUCT ?? | Excel Discussion (Misc queries) | |||
| Sumproduct question | Excel Worksheet Functions | |||
| Sumproduct question | Excel Worksheet Functions | |||
| Sumproduct question | Excel Worksheet Functions | |||
Linear Mode
