#1
|
|||
|
|||
Sum with criteria
Hi All,
I have this problem and after many days I can't figure out the solution. See attachment (2 sheets) 1 with formula for 1 symbol, 1 strategy, other sheet is multiple symbols and strategies; Theory After a loss, the Drawdown starts counting When the sum of results column (W/L) >0 then Drawdown returns 0 Then, when a loss occurs again, Drawdown starts sum up, till it is made up by winners, and again returns a 0. Problem When more Symbols and strategies in a table, I can't figure out the right formula. Hopefully someone here can. Really appreciate it. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create a unique list of values that match a criteria, sorted in order of another criteria | BradRichardson | Excel | 2 | 01-03-2017 12:25 AM |
Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached. | phillipsdp | Excel | 1 | 11-09-2016 12:53 AM |
SUM up values when different criteria are met | Ewitschka | Excel | 2 | 07-18-2016 02:40 AM |
how to look up for multiple criteria | piper7971 | Excel | 5 | 06-16-2015 03:42 AM |
Matching Criteria against a range when criteria is not in contiguous cells?? | GMorris | Excel | 9 | 08-20-2014 02:15 AM |