Results 1 to 7 of 7

Calculate TRIMMEAN with multiple conditions

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-15-2012
    Location
    Dallas, TX
    MS-Off Ver
    2019
    Posts
    167

    Calculate TRIMMEAN with multiple conditions

    I want to expand on the below formula, located @ RESULTS 1 Q3 in the attached WB. I want to add a couple conditions...

    =TRIMMEAN(IF(Table1[MAX GAIN]>=4,Table1[POINTS G/L]),10%)
    Add the following conditions...

    IF Table1[EXIT REASON] = "5x20"
    IF Table1[MAX GAIN] ">=4" counts >= 5
    Attached Files Attached Files
    Last edited by cableghost; 10-19-2021 at 01:08 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate quantity based on multiple conditions
    By ThrillJunkie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2021, 06:56 PM
  2. Calculate total based on multiple conditions
    By antonywijesinghe in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-23-2018, 02:57 AM
  3. Calculate Median with multiple conditions
    By Masun in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-23-2017, 05:54 AM
  4. Calculate with multiple conditions
    By sasajo1 in forum Excel General
    Replies: 9
    Last Post: 01-29-2017, 01:49 PM
  5. [SOLVED] Trimmean function with multiple if criteria
    By qcjustin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-10-2016, 01:28 PM
  6. Replies: 5
    Last Post: 03-23-2012, 11:59 AM
  7. Calculate Values based on Multiple Conditions
    By creativefusion in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-24-2009, 09:27 PM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1