Hello again,
I have had computer problems. I will re-check with the formula's that you
all have submitted. Thanks for your help for now. I will get back to you
all.

Rich

"Bob Phillips" wrote:

=SUM(IF((A2:A20="Location")*(B2:B20="Product"),C2: C20/D2:D20))

this is an array formula, so commit with Ctrl-Shift-Enter, not just Enter

--
__________________________________
HTH

Bob

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