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