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!!