YTLE#111: Excel AVERAGE w Multiple Criteria

I need to find the average of a column with multiple criteria.

For eg:

Type Stories Price House second $45,687 House second $159,863 House first $65,563 Condo second $23,556 Condo first $35,896 House second $458,852 House second House first $215,586 Apartment first $23,665 Apartment first $98,556 House second $75,665 Condo first $85,665

And I need to get the result as

Average price 1 story house 2 story house 1 story condo 2 story condo 1 story apartment 2 story apartment


Please help me to get the solution. I tried the combination of average and if but could not succeed.

Regards,
Deeps

I have workbook with two sheets in the 1st sheet is my monitoring and on the 2nd sheet is the analysis. I need to get the number of files the encoder finished per day (undefined is not included) and their average time spent per day. By the way I'm using excel 2003.

I have 3 columns of data.

Column A contains text. Either "PP" "DP" or "SP"
Column B contains dates. Either TODAY() or dates in the past.
Column C contains numbers of days.

All three columns also contain some blanks.

I want to AVERAGE the days (Column C) where the date (Column B) does not equal TODAY() and Column A contains "PP".

Thanks.

I tried writing an OR multiple criteria to work out averages from a column of data, but seem to be getting different results to manual calculations.
Can anyone assist in writing a single formula for the following multiple ones?

{=IF(B62=0,"0",AVERAGE(IF((Sheet1!H10:H65536="ARP"),Sheet1!I10:I65536)))/1440}
{=IF(B62=0,"0",AVERAGE(IF((Sheet1!H10:H65536="ART"),Sheet1!I10:I65536)))/1440}
{=IF(B62=0,"0",AVERAGE(IF((Sheet1!H10:H65536="AP"),Sheet1!I10:I65536)))/1440}
{=IF(B62=0,"0",AVERAGE(IF((Sheet1!H10:H65536="AH"),Sheet1!I10:I65536)))/1440}

B62 is just a COUNTIF formula to see if there's any "A*" entries in the range H10:H65536.

I tried {=AVERAGE(IF(OR(Sheet1!H10:H65536="ARP",Sheet1!H10:H65536="ART",Sheet1!H10:H65536="AP",Sheet1!H10:H65536="AH"),Sheet1!I10:I65536))/1440}
But got different results.

Hi There i have the following 2 sheet work book,

Back sheet:
Column A - A list of client Names
Column B - A list of areas
Column C - the average time taken to do a task.

on the front sheet i need to have a formula that will calculate the average time if the criteria meet both the Name and the are. As i have clients with the same name but in diffrent areas. i want to try avoid using pivot tables as the front sheet has more data on and would liek to use a single formula in the cell.

is this possible ?

Many thanks

For Employee A, I need to calculate the average number of days it takes him to fill his positions by year. I try using an average formula, but come up with a zero.

Employee Function Position # of days to fill Year Employee A HR Position 1 16 2010 Employee B Operations Positioin 2 73 2010 Employee A Finance Position3 48 2010 Employee C Sales Position 4 48 2010 Employee A SC-I Position 5 32 2010 Employee A Executive Position 6 105 2011 Employee C Marketing Position 7 64 2011
Employee A HR Positioin 8 42 2011

Is this possible?

Hi all,

I'm new to excel programming. I'm task to compute the average if several criteria is met. I have output.xls and inside this workook there is a button. When a user click this button, it will calculate for them the average. And I have another workbook, data.xls that has a total of 40 columns and 40640 rows(The data will get bigger). I have to find the average by month,week,service,testname and result. The result of this average will be in output.xls

Is there any macro to write so they know when to find the average? I'm using excel 2003. I don't even know where and how to start. So far I only tried the AVERAGE(IF(......
However,it is not efficient and sometimes it will come out an error.

Anybody can help?

Thanks in advance

Okay I have Excel 2003 and I am trying to get the average with certain criteria over multiple sheets.

In column A displays a Name. In column B will display a percentage between 0% to 100% this is across 4 sheets.
Sheet1
John 75%
Jake 80%
John 89%
Dave 45%

Sheet2
John 70%
Jake 25%
John 30%
Dave 90%

Ect

Now I'm trying to get the average of percent with the criteria of only "John" from Sheet1:Sheet4.

A B C D
1 Ticket Opened Closed Status
2 12345 1/1/2011 Open
3 12346 1/2/2011 2/2/2011 Closed
4 12347 1/3/2011 2/3/2011 Closed
5 12348 1/4/2011 2/4/2011 Closed
6 12347 1/4/2011 2/3/2011 Closed
7 12349 1/5/2011 2/5/2011 Closed

Okay, I cant figure this one out and I am new to arrays...

I need a formula that picks the unique tickets, then averages the number of days the ticket was open, with the criteria that the ticket is Closed and is <= 2/3/2011 and puts the average is cell E1.

The system may have one ticket, but if we assign 5 units to a single ticket, a report shows all 5 in the report as individual rows. So even though there is a single ticket, taking the average of duplicates skews the information. I hope that explanation of the duplicates makes sense.

Thanks in advance.