| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)) ?? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)) ?? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)) ?? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)) ?? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)) ?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =IF(B1,"",SUMPRODUCT(--(B$1:B$5=""),--(A1<A$1:A$5))+1), Biff formula | Excel Worksheet Functions | |||
| SUMPRODUCT(--ISNUMBER(FIND("AM",C5:160))*(k5:k160="") | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| "If this, multiply by this" type of equation | Excel Worksheet Functions | |||
![Harry Seymour[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
