MAX & MIN functions with conditions.....

Hello friends,

I am working on finding performance on a sample data... I am facing a hurdle with finding the MAX and MIN with conditions. Will appreciate help on the same...

I am attaching the file for better understanding..... The problem cells have "?" in red color in them... I have also commented cells to explain....

For maximum profit and loss

in AC23
=MAX(IF(AND(C$2:C$1000="BUY")*((J$2:J$1000="Target Achieved")+(J$2:J$1000="Stop Loss Hit")+(J$2:J$1000="Expired")),K$2:K$1000))
in AD23
=MAX(IF(AND(C$2:C$1000="SELL")*((J$2:J$1000="Target Achieved")+(J$2:J$1000="Stop Loss Hit")+(J$2:J$1000="Expired")),K$2:K$1000))
in AC24
=MIN(IF(AND(C$2:C$1000="BUY")*((J$2:J$1000="Target Achieved")+(J$2:J$1000="Stop Loss Hit")+(J$2:J$1000="Expired")),K$2:K$1000))
in AD24
=MIN(IF(AND(C$2:C$1000="SELL")*((J$2:J$1000="Target Achieved")+(J$2:J$1000="Stop Loss Hit")+(J$2:J$1000="Expired")),K$2:K$1000))

NOTE: These are all array formulas
Array formula, use Ctrl-Shift-Enter

Change the conditions as defined by your comments to suit other cells.

AC=SUMPRODUCT(MAX(($C$2:$C$401=AC$1)*($J$2:$J$401<>"Active")*($K$2:$K$401)))
Try this
see the attached file
Note: Don't include words like "Help","Urgent Help", "Please Help", "Formula Help" at any point of time in your thread Title in future, I suggest you change your thread title.