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!