Hi

One way

Assuming your data is in columns A:D
Insert 2 rows above your header. In C1 type Max, in C2 type Min.
In D1 enter
=SUBTOTAL(4,D4:D1000)
In D2 enter
=SUBTOTAL(5,D2:D1000)
(make the range long enough to cover your data range in each case)

Highlight A3:D3DataFilterAutofilter
Use the dropdowns in row 3 to make whatever selection you wish.

--

Regards
Roger Govier

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