Spreadsheet: 721057d1614445591-help-proof-a-formula-with-sumproduct-and-average-average-days-held-sample-proof
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 |  | SUM(T)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 |  | COUNT(T)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 |  | U1/U2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 |  | same?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43
 |  |  |  |  | Status | Symb. | Qty | Days Held |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  | Closed | NLY | 5 | 43 |  |  |  | NLY |  | <<< Formula A |  |  |  |  | 36
 |  |  |  |  | Closed | NLY | 5 | 36 |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  | Open | AGNC | 5 | 26 |  |  |  | NLY |  | <<< Formula B |  |  |  |  | 36
 |  |  |  |  | Closed | NLY | 5 | 134 |  |  |  |  |  |  |  |  |  |  | 134
 |  |  |  |  | Closed | NLY | 5 | 208 |  |  |  |  |  |  |  |  |  |  | 134
 |  |  |  |  | Closed | NLY | 5 | 50 |  |  |  |  |  |  |  |  |  |  | 134
 |  |  |  |  |  |  |  |  |  |  | In my original template There are Multiple Symbols, Qty, Status and Days. |  |  |  |  |  |  |  | 134
 |  |  |  |  | Closed | NLY | 5 | 78 |  |  | I Need to Calculate The average Days these multiple Positions were Held |  |  |  |  |  |  |  | 134
 |  |  |  |  | Closed | AGNC | 5 | 130 |  |  |  |  |  |  |  |  |  |  | 208
 |  |  |  |  |  |  |  |  |  |  | I am Not Sure If [NAME] is Correct. I know [NAME] is incorrect |  |  |  |  |  |  |  | 208
 |  |  |  |  | Closed | NLY | 2 | 204 |  |  | Can Someone Proof Formula A ? |  |  |  |  |  |  |  | 208
 |  |  |  |  |  |  |  |  |  |  | And If [NAME] is [NAME], What would be the Correct Formula? |  |  |  |  |  |  |  | 208
 |  |  |  |  | Open | NLY | 2 | 204 |  |  |  |  |  |  |  |  |  |  | 208
 |  |  |  |  | Closed | NLY | 1 | 204 |  |  | Thank you:) |  |  |  |  |  |  |  | 50
 |  |  |  |  | Closed | AGNC | 5 | 130 |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  | Closed | AGNC | 3 | 125 |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  | Closed | NLY | 2 | 125 |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  | Open | NLY | 5 | 32 |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  | Closed | NLY | 1 | 86 |  |  |  |  |  |  |  |  |  |  | 78
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 78
 |  |  |  |  | Open | NLY | 1 | 160 |  |  |  |  |  |  |  |  |  |  | 78
 |  |  |  |  | Closed | AGNC | 1 | 58 |  |  |  |  |  |  |  |  |  |  | 78
 |  |  |  |  | Closed | NLY | 10 | 15 |  |  |  |  |  |  |  |  |  |  | 78
 |  |  |  |  | Closed | NLY | 10 | 88 |  |  |  |  |  |  |  |  |  |  | 204
 |  |  |  |  | Closed | NLY | 5 | 86 |  |  |  |  |  |  |  |  |  |  | 204
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 204
 |  |  |  |  | Open | NLY | 9 | 0 |  |  |  |  |  |  |  |  |  |  | 125
 |  |  |  |  | Closed | NLY | 10 | 71 |  |  |  |  |  |  |  |  |  |  | 125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86
 |  |  |  |  | Closed | AGNC | 4 | 0 |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  | Closed | NLY | 4 | 0 |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  | Closed | NLY | 2 | 0 |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  | Open | AGNC | 5 | 0 |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  | Closed | AGNC | 1 | 0 |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  | Closed | AGNC | 10 | 0 |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0