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!

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!

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!