=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