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
Try debugging the formula usingg the following
Tools - formula auditing - evaluatte formula Post where the problem is occuring. "Karen Smith" wrote: 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 | |||
SumProduct Question | Excel Worksheet Functions | |||
Sumproduct question | Excel Worksheet Functions | |||
Sumproduct ?? Question | Excel Worksheet Functions | |||
sumproduct question | Excel Worksheet Functions |