MINIMUM - CONDITIONAL

[FARAZ QURESHI]

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!

 

[T. Valko]

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)

 

[Roger Govier]

Hi

One way

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

Highlight A33>Data>Filter>Autofilter
Use the dropdowns in row 3 to make whatever selection you wish.