If Else finds Average

No, it is not possible without more details

blabla,

Please explain in more detail.

Please attach your workbook, by clicking on the New Post button, then scroll down and see the Manage Attachments button.

Hi blabla;

The short answer is yes it's possible. But nobody can help you write the macro without more information.

Some of the things people need to know:
1. How is the macro triggered? By a validation? By a button? By a menu item? or how?
2. What are the tests to decide whether to calculate the average?
3. What will the macro do with the answer after it calculates it?

Hi blabla;

I can not figure out what you want done.

I think you want these steps.
1) The user will enter criteria In N23:N27.
2) The user clicks "Average"
3) The macro will go to another workbook and look for the "testname" and average the #s it finds in that other workbook. A sample of the other workbook is in K34:O39.

If the #s to average are in the other workbook, how can a macro in this workbook do it without the other workbooks name?
Where do yo want the result put?
What are the other criteria besides testname for?

The DAVERAGE should be able to use another workbook, but I still can not understand how you expect it to work.
When the user enters testname, month, week, result2, and service, there is no problem finding the correct FTP DL, but I don't see what there is to average. Maybe if you provided average.xls it would make more sense to me.

Hi blabla;

I still don't see anything to average. Column K in average.xls is Hour column. There is only 1 row with testname = "Central" and service = "FTD", and Column K on that row is 0.

Try showing us what is averaged when testname = Central, service = FTD, Month = 12, Week = 45, Result2 = 1

I'm sorry blabla;

I still can not see what you want averaged.
Try making more sheets:
Sheet 1 - shows blank user entry.
Sheet 2 - shows what it looks like after user types in something
Sheet 3 - shows results after user clicks button.