Try these array formulas** :

=MIN(IF((area="II")*(product="C"),amount))

=MAX(IF((area="II")*(product="C"),amount))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"FARAZ QURESHI" wrote in message
...
I have a sheet presenting 4 major columns as:

CLIENT AREA PRODUCT AMOUNT

I would appreciate a formula for finding the minimum & maximum amounts for
cases in AREA: "II" and PRODUCT: "C".

Kindly help me out urgently.

Thanx in advance!