View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MrRJ MrRJ is offline
external usenet poster
 
Posts: 109
Default Sumproduct dvision

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