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

[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),(D110))

??

 

[Bob Phillips]

This is using the documented part of SP <G>

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

--
HTH

Bob

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

 

[Mike H]

almost, try:-

=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10="A"),(C1:C10*D110))

Mike

 

[Harry Seymour]

Bob,

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

Any thoughts?

Thanks
Harry

 

[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)