I'll just cut to it:

I'm looking for a way to get an average cost per site per vendor.

So:
Site list (can be multiple/and duplicate) for a given vendor, at $x/given site value.

Any thoughts?

Example:
Code:
Site       $        Vendor
AB12   600    Company
AC15   200    Company
AD94   700    Company
AC15   400    Company
AN82   500    Company
PH77   400    Company

So, in the end:
Company has $2800 over 5 unique sites. Or an average of $560 average per site.

There are roughly 3000 lines and 25-30 "vendors"...


Fucking Excel.


Thoughts?