=SumProduct(A1:A10="Name1"),--(B1:B10="Y),-- C1:c10)

I am trying to use sum prodruct to do a running total on Name1 when col B
is =Y
I am not familiar with the syntax but I kno the above formula does not work
Can someone correct my formula.

thanks

=SumProduct(--(A1:A10="Name1"),--(B1:B10="Y),C1:c10)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Akira" wrote in message
...
=SumProduct(A1:A10="Name1"),--(B1:B10="Y),-- C1:c10)

I am trying to use sum prodruct to do a running total on Name1 when col
B
is =Y
I am not familiar with the syntax but I kno the above formula does not
work
Can someone correct my formula.

thanks

Try
=sumproduct(--(a1:a10="Name1"), --(b1:b10="Y"), (c1:c10))

"Akira" wrote:

=SumProduct(A1:A10="Name1"),--(B1:B10="Y),-- C1:c10)

I am trying to use sum prodruct to do a running total on Name1 when col B
is =Y
I am not familiar with the syntax but I kno the above formula does not work
Can someone correct my formula.

thanks

Try this:-

=SumProduct(--(A1:A10="Name1"),--(B1:B10="Y"),(C1:C10))

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"Akira" wrote in message
...
=SumProduct(A1:A10="Name1"),--(B1:B10="Y),-- C1:c10)

I am trying to use sum prodruct to do a running total on Name1 when col
B
is =Y
I am not familiar with the syntax but I kno the above formula does not
work
Can someone correct my formula.

thanks