Sumproduct dvision
Yes, in a sense that is what columns C & D I was stating below is.
"John C" wrote:
Oh, and also to clarify, you are actually wanting the values in column P
multiplied by column M, according to your formula, is that also correct?
--
John C
"MrRJ" wrote:
Hi John,
Take a look what I have. The number given is incorrect. What did I do wrong.
The values for column C is
166.250
83.120
124.680
249.370
249.370
124.680
290.930
166.250
207.810
The values for column D a
$19.68
$19.68
$19.68
$19.68
$19.68
$19.68
$19.68
$19.68
$19.68
Using this formula, I get the value of 88,648.56. I should have 32,717.21.
Basically, I need the sum of C x D. Does that make sense?
=SUMPRODUCT(--('[CCDS_PEP_Audit_Transaction_Receipt_Report_PAS_P920 08_090808.xls]PAS
P9
wkst'!$A$2:$A$11818=B227),--('[CCDS_PEP_Audit_Transaction_Receipt_Report_PAS_P920 08_090808.xls]PAS
P9
wkst'!$C$2:$C$11818=A227),'[CCDS_PEP_Audit_Transaction_Receipt_Report_PAS_P920 08_090808.xls]PAS
P9
wkst'!$P$2:$P$11818)*'[CCDS_PEP_Audit_Transaction_Receipt_Report_PAS_P920 08_090808.xls]PAS P9 wkst'!$M$2:$M$11818
"John C" wrote:
Assuming I understand you correctly....
=SUMPRODUCT(--($A$2:$A$100=location),--($B$2:$B$100=product),($C$2:$C$100)*($D$2:$D$100))
Hope this helps.
--
John C
"MrRJ" wrote:
John,
sorry about that. Here is further clarification. Perhaps I can state it
this way.
I need the sum of volume x rate. This is based on 2 criteria I set for
location and Product.
Location Product Volume Rate
Hope this clears it?
Rich
"John C" wrote:
Perhaps further clarification on your formula is needed. Sum of volume * (Sum
of Amount / Sum of Volume) will be equal to Sum of Amount.
--
John C
"MrRJ" wrote:
Good morning!
I am using Sumproduct in my spreadsheet. I am trying to do a division
within. Here is my problem.
Location Product volumn Amount
I need to match the location and product, once that is done, then I need to
do sum of volume * (sum of amount / sum of volume).
Hope this makes sense.
Thanks,
Rich
|