Another question please....if I have another condition, how do I do this? Say
I have another column of nationalities, and I then need to calc the min/max,
etc of American drivers, English drivers and Australian drivers?

I tried to nest some "if" functions....but screwed it up......hopefully
you'll have the answer!

"Biff" wrote:

Hi!

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=MIN(IF(C1:C100="Driver",D1:D100))

Use the same syntax for each of the other functions.

Biff

"Al" wrote in message
...
I have two columns: column C has job functions, say engineer, cook, driver,
etc; column D has salaries.

I want to analyse the salaries: what's the min/max,median, mode, average
values for each of the job functions. (e.g., if data in column C =
"driver",
then corresponding salary to be included in the data to be analysed.)

Hope someone out there has the answer!!