how to multiply a =sumproduct(--(A1:A10,"Jon"), by value in row

H

Harry Seymour

I've now worked out how to use the following formula:

=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10=B"),(C1:C10))
which gives me the summed value for jon & B's.

I have now realised that I have a volume column that shows how many of that
particular row there needs to be in the summed value.
e.g.
Name Category Value Volume
Jon A £20 2
Max A £40 1
Jon B £30 3
Mary A £35 2

Would i simply add this extra piece?

=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10=B"),(C1:C10),(D1:D10))

??
 
B

Bob Phillips

This is using the documented part of SP <G>

=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10="B"),C1:C10,D1:D10)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
H

Harry Seymour

Bob,

For some reason this isn't working for me. the equation without D1:D10
works, but adding this new section returns #VALUE

Any thoughts?

Thanks
Harry
 
B

Bob Phillips

Hard to say as it works fine for me.

What are you seeing?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

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

Top