+ Reply to Thread
Results 1 to 3 of 3

Trimmean Summary

Hybrid View

  1. 09-08-2020, 11:27 AM #1
    oneyejack77
    oneyejack77 is offline
    Registered User
    Join Date
    05-26-2017
    Location
    Burnsville, MN
    MS-Off Ver
    2016
    Posts
    50

    Trimmean Summary

    I'm looking to run a productivity comparison using trimmean. I have a set of raw data that gives me a task type, a tech and the amount of time it takes to complete that task. I first want to summarize the trimmean for specific task types regardless of tech completing the task. I then want to summarize the trimmean for each tech for a given task for comparison. Trimmean is necessary to get rid of the fluff. I'm stuck, any help would be great. Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-08-2020, 02:43 PM #2
    Bo_Ry
    Bo_Ry is offline
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,222

    Re: Trimmean Summary

    Please try at
    H6
    =TRIMMEAN(IF($B$2:$B$61=G6,$C$2:$C$61),10%)

    I15
    =TRIMMEAN(IF($A$2:$A$61=G15,IF($B$2:$B$61=H15,$C$2:$C$61)),10%)
    Attached Files Attached Files
    Linkedin/Bo-Rydobon
    Youtube.com/XcWizard
    Facebook.com/XcWizard
    Reply With QuoteRegister To Reply
  3. 09-08-2020, 09:53 PM #3
    wk9128
    wk9128 is offline
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2502 and WPS V2024(12.1.0.18543)
    Posts
    3,866

    Re: Trimmean Summary

    H6 cell , Array formula
    HTML Code: 
    I15 cell , Array formula
    HTML Code: 
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Trimmean using subtotal or aggregate
    By excelnabb in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 02-19-2019, 06:17 PM
  2. [SOLVED] Trimmean help to ignore 0
    By jonoman1234 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-19-2017, 03:08 AM
  3. Trimmean to ignore #div/0!
    By Nevada511 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-14-2017, 04:33 AM
  4. Alternative TRIMMEAN
    By Brennen81 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-06-2015, 09:29 AM
  5. [SOLVED] Using TRIMMEAN on a selection of data
    By Krogerstrom in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-05-2013, 06:50 AM
  6. [SOLVED] TRIMMEAN & OFFSET together
    By JTM1200 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-11-2012, 05:23 PM
  7. [SOLVED] TRIMMEAN with different percentiles?
    By agbiggs@hotmail.com in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-14-2006, 01:15 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1