Largest Negative Daily Total

[tysonmax]

Hello Everyone,

I need your help!
I have a problem where I need to find the largest negative daily total in a table.
I have the largest daily sum total with the following: MAX(SUMIFS(Values[P/L],Values[Date],ROW(INDIRECT($L$3&":"&TODAY()))))

L3 is the

Starting Date, L31 is a starting date for a range and the ending range is L32.

<tbody>
</tbody>

TOTAL LOSS : SMALL(Values[P/L],1))
YEARLY LOSS : MIN(IF(Values[Date]>=$L$31,Values[P/L]))>=0,"No Values Found",MIN(IF(Values[Date]>=$L$31,IF(Values[Date]<=L$32,Values[P/L])))))

I can also find the largest value that's a negative value if I specify the whole table or a range but not sure how to do the same but for a daily total sum.
Is anyone able to help? I really appreciate the help in advance!

 

[tysonmax]

Sorry I should have also said I an trying to find the largest negative daily value in the table and also for the yearly range. Thank you!