Sumprodruct

G

Guest

=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
 
B

Bob Phillips

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

--

HTH

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

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Variable Sumproduct Range 6
text to date..! 3
Scrabble Value calculation for Welsh words 0
how to multiply a =sumproduct(--(A1:A10,"Jon"), by value in row 4
And,if,true Help 4
Formula problem 3
another sumproduct with #value error... 5
Sumif where sum range is more than one column? 1

Top