Dmax with 2 criteria

[MI man]

I have a database in one spreadsheet and table on another spreadsheet.
The database would have the data of all the months....
There would be a field named TAT (which is a number)

The fields required:

Month
TAT
Centre (centre is an area of work, say Birmingham, Yorkshire, etc.)

So, I want to find out the maximum, minimum and average TAT for each Centre for a selected month (There is a combo box to select the month. Upon selecting the month, the table pulls the values (mostly counts for which I have used SUMPRODUCT) according to the month selected from the whole database)

Tried working out with DMAX, DMIN and DAVERAGE, but not able to crack the multiple criteria with it..

Help...!!!

 

[namliam]

When you want multiple values from one set of data, your not to use the D functions.
Each D function does a seperate search which can endup being ultimatly SLOoooooooooow as hell.

Try using a "proper" sql and retrieving the data that way.

 

[MI man]

Thank you mailman for your quick reply.

However, please tell me if sql query runs effectively in Excel, for I have tried sql in Access VBA but not Excel VBA.

And, I have both the data spreadsheet and table spreadsheet in a single workbook....(say sheet1 and sheet2 of the same workbook)

 

[namliam]

Access VBA or Excel VBA, no difference

DMax, Danything is to do with searching in tables, access tables preferably.
If you want max in excel sheets you want the normal max function? And doing multiple criteria in excel is IMPOSSIBLE.
You can fake it, by concatinating 2 columns then basing of that. But basicaly excel is a 1 way 1 criteria 1 formula kinda beast.

 

[MI man]

Thank you mailman for the prompt response....