AVERAGE of AVERAGEIFS problem

R

RobofMN

=AVERAGE(AVERAGEIFS(Completes!$E$2:$E$1000,Completes!$D$2:$D$1000,{"12/1/2008","11/1/2008","10/1/2008"}))
=median?

I'm need to do an average & median of the 3 month total of defects per
completed product from a factory. The formula above seems to come close for
the average I need but it is averaging each month seperate and then averaging
those 3 totals instead of averaging all 3 months as 1 group of numbers.

On the Completes tab each row has the part number, serial number, month
completed, defects total for that serial number.

SERIAL_NO START_DATE COMPLETE_DATE Month Defects
3100 29-Jan-09 29-Jan-09 Jan-09 1
36189 21-Jan-09 21-Jan-09 Jan-09 3
36190 05-Jan-09 05-Jan-09 Jan-09 6
Please help :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Averageifs & median 1
Can Excel display the ratio of two numbers? 1
IF(AND)Etc..... 3
Number of days in overlapping date ranges (using array formula?) 7
Average a group of numbers within an date range. 4
When building a chart Dates are been included that are not in thedate range 2
Lookup and average data in an unsorted list 1
Offset formula 2

Top