Results 1 to 5 of 5

Thread: Excel Help (ahem, Keith)

  1. #1
    Female Masturbatory Aid
    Join Date
    Jan 2014
    Location
    JAX
    Posts
    1,580

    Excel Help (ahem, Keith)

    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?

  2. #2
    Corvette Enthusiast Kchrpm's Avatar
    Join Date
    Jan 2014
    Location
    Cincinnati, OH
    Posts
    6,529
    Sumifs/Countifs

  3. #3
    'Trep dodint's Avatar
    Join Date
    Jun 2016
    Location
    WTB: Slicktop E46 330CI w/manual
    Posts
    2,148
    hah

  4. #4
    Female Masturbatory Aid
    Join Date
    Jan 2014
    Location
    JAX
    Posts
    1,580
    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?

  5. #5
    Corvette Enthusiast Kchrpm's Avatar
    Join Date
    Jan 2014
    Location
    Cincinnati, OH
    Posts
    6,529
    Fuck Pivot tables.

    https://docs.google.com/spreadsheets...it?usp=sharing

    Something like that?
    Get that weak shit off my track

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •