Sumproduct dvision
Try
=sumproduct(--(a1:a100="Location"),--(b1:b100="Product),(c1:c100)/(sumproduct(--(a1:a100="Location"),--(b1:b100="Product),(c1:c100)
+ sumproduct(--(a1:a100="Location"),--(b1:b100="Product),(d1:d100))
No error checking provided.
"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
|