Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Average If using trimmed mean

0

I included a small sample of the data but have a much large data set with 4 categories. I also want to trim the mean because there are outliers. So if you were to choose Warehouse A, and the channel as Big Box the toys R Us average of 225 is really going to throw the number off. Any suggestions on how to do it when I make choices on the categories.

Answer
Discuss

Answers

0

I had formula in Cell J4   ~ =AVERAGEIFS($E$2:$E$46,$A$2:$A$46,"A*",$D$2:$D$46,"Big Box*",$C$2:$C$46,"Toys R Us").  check out AverageIfs.  Average is AVERAGE

Discuss

Discussion

I was just using Toys R Us as an example. Im looking for Warehouse A and the channel as Big box. I also need to use Trimmed Mean to get rid of the 225 in row 35.
Brad1984 (rep: 2) May 30, '17 at 3:27 pm
sorry, i'm not familiar with the function, but look into http://www.excelfunctions.net/Excel-Trimmean-Function.html.  What could be done is put data into Pivot table, then Segregate the results for what you would like (i.e. Ware House A; Toys R US & Big Box) then use trimmean function?
queue (rep: 467) May 30, '17 at 3:43 pm
Thank you for your responses, after some digging I found what I need to do.
Brad1984 (rep: 2) May 30, '17 at 4:06 pm
Please share the answer if you found it so future visitors can figure this out if they have the same issue.
don (rep: 1989) Jun 4, '17 at 1:21 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login