sum max constative based on criteria

[Excel777]

Hi all
i use this formula to count max constative positive and negative numbers,
MAX(FREQUENCY(IF($AI$16:$AI$3000="WIN",ROW($AI$16:$AI$3000)),IF($AI$16:$AI$3000<>"",IF($AI$16:$AI$3000<>"WIN",ROW($AI$16:$AI$3000)))))
MAX(FREQUENCY(IF($AI$16:$AI$3000="LOSS",ROW($AI$16:$AI$3000)),IF($AI$16:$AI$3000<>"",IF($AI$16:$AI$3000<>"LOSS",ROW($AI$16:$AI$3000)))))
i need a formula to sum max constative positive and negative numbers,
any help
thanks

 

[maabadi]

then What is your numbers columns that you want sum?
If your SumRange Column is AM Then:

=SUMIF($AI$16:$AI$3000,"Win",$AM$16:$AM$3000)

=SUMIF($AI$16:$AI$3000,"Loss",$AM$16:$AM$3000)

 

[maabadi]

You're Welcome & Thanks for feedback