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

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

??

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

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)

"Harry Seymour" wrote in message
...
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))

??

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

almost, try:-

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

Mike

"Harry Seymour" wrote:

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

??

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

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

"Bob Phillips" wrote:

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)

"Harry Seymour" wrote in message
...
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))

??

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

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)

"Harry Seymour" wrote in message
...
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

"Bob Phillips" wrote:

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)

"Harry Seymour" wrote in message
...
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))

??