Excel Help (ahem, Keith)

[drew]

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:


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?

[Kchrpm]

Sumifs/Countifs

[dodint]

hah

[drew]

Ok... to elaborate, to put this in a pivot table?


Select vendor, results in average cost of site, factoring in duplicates for sum, but only uniques for average?

[Kchrpm]

Fuck Pivot tables.

https://docs.google.com/spreadsheets/d/15uG2HpQtbhp80Rb_ym8pshOjgh0WSAijL_9VkjukjRA/edit?usp=sharing

Something like that?