Thread: Sumprodruct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Akira
 
Posts: n/a
Default Sumprodruct

=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