Average with multiple criteria in another workbook

[blabla]

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

[venkat1926]

I am thinking that if month,week,service,testname and result. are column heading why not do a pivot table.

[blabla]

I'm not allowed to use pivot table. Pivot has been done. Now it's more to like a summary worksheet in another workbook. Any more suggestion?

[foxguy]

Hi blabla;

Is this the same question as http://www.excelforum.com/excel-prog...s-average.html

[blabla]

No it is not. For this question I do not know how to do it. For the other one I know which statement to use but just not sire if it is correct as I'm new to VBA and DAVERAGE. Thank you

[foxguy]

I can not see a difference between the 2 questions. Maybe if you provided averages.xls it would make more sense.