Solved

How do I calculate an Average Cycletime based on separate criteria?

Posted on 2011-09-15
2
157 Views
Last Modified: 2012-05-12
Hello experts:

See attached sample.  How can I calculate the average cycletime for only those orders that match each zone?

Thanks,

Gary
Cycletime-Avg-per-Zone-EE.xls
0
Comment
Question by:garyrobbins
2 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 36546550
Hello Gary, try this formula in C16 copied down

=SUMIF(B$2:B$8,B16,C$2:C$8)/MAX(1,COUNTIF(B$2:B$8,B16))

regards, barry
0
 

Author Closing Comment

by:garyrobbins
ID: 36546573
Thanks, Barry.  Great formula.  

Take good care,
Gary
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now