See
http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"PaladinWhite" wrote in message
...
You've both explained it very well... I see that the -- is simply allowing
the value of the next statement to act as an "eliminator" of sorts so I
only
get multiplication through on the rows that I wanted.
I can already think of other places where I can implement that trick.
Thanks
again.
"Tyro" wrote:
Simple matter of coersion, "--" or "*" in this case.
Tyro
"PaladinWhite" wrote in message
...
Hey, that works too! Thanks, Tyro.
"Tyro" wrote:
=SUMPRODUCT((A1:A5="yellow")*B1:B5*C1:C5)
Tyro
"PaladinWhite" wrote in
message
...
I find myself asking a lot of questions on these boards lately...
Thank
you
to all you great people that make the time to help!
I'm trying to multiply values in Columns B and C , like SUMPRODUCT()
would
do - the catch is that I only want to multiply pairs where the
corresponding
cell in Column A contains the text "YELLOW". For instance, in this
case:
PURPLE | 1 | 3
YELLOW | 2 | 6
PURPLE | 3 | 9
YELLOW | 4 | 12
PURPLE | 5 | 15
... I would want to return [(2*6) + (4*12)] = 60.