Spreadsheet: 42583d1241116229-sumproduct-error-defects-log
Sheet: Def 1

Status | Age | Severity | Def found date
Closed | 202.3623032407413 | 2 | 2008-10-09 15:18:17
Closed | 202.3554976851883 | 2 | 2008-10-09 15:28:05
Closed | 201.5751620370356 | 2 | 2008-10-10 10:11:46
Closed | 201.5441782407433 | 2 | 2008-10-10 10:56:23
Closed | 201.5371180555521 | 2 | 2008-10-10 11:06:33
Closed | 198.5862384259235 | 2 | 2008-10-13 09:55:49
Closed | 198.5440972222204 | 2 | 2008-10-13 10:56:30
Closed | 198.5095486111095 | 2 | 2008-10-13 11:46:15
Closed | 197.4975694444438 | 2 | 2008-10-14 12:03:30
Closed | 196.451261574075 | 2 | 2008-10-15 13:10:11
Closed | 195.4229282407396 | 2 | 2008-10-16 13:50:59
Closed | 194.3904629629615 | 2 | 2008-10-17 14:37:44
Closed | 198 | 2 | 2008-10-14 00:00:00
Closed | 197 | 2 | 2008-10-15 00:00:00
Open | 197 | 2 | 2008-10-15 00:00:00
Closed | 197 | 2 | 2008-10-15 00:00:00
Closed | 197 | 4 | 2008-10-15 00:00:00
Closed | 114 | 2 | 2009-01-06 00:00:00
Closed | 114 | 2 | 2009-01-06 00:00:00
Closed | 114 | 2 | 2009-01-06 00:00:00
Closed | 107 | 3 | 2009-01-13 00:00:00
Closed | 71 | 3 | 2009-02-18 00:00:00
Closed | 71 | 2 | 2009-02-18 00:00:00
Closed | 70 | 3 | 2009-02-19 00:00:00
Closed | 70 | 2 | 2009-02-19 00:00:00
Closed | 70 | 2 | 2009-02-19 00:00:00
Closed | 70 | 2 | 2009-02-19 00:00:00
Closed | 70 | 2 | 2009-02-19 00:00:00
Closed | 70 | 2 | 2009-02-19 00:00:00
Closed | 50 | 2 | 2009-03-11 00:00:00
Closed | 36 | 3 | 2009-03-25 00:00:00
Closed | 70 | 2 | 2009-02-19 00:00:00
Closed | 69 | 3 | 2009-02-20 00:00:00
Closed | 69 | 2 | 2009-02-20 00:00:00
Closed | 66 | 2 | 2009-02-23 00:00:00
Closed | 66 | 2 | 2009-02-23 00:00:00
Closed | 66 | 3 | 2009-02-23 00:00:00
Closed | 66 | 2 | 2009-02-23 00:00:00
Closed | 66 | 2 | 2009-02-23 00:00:00
Closed | 66 | 2 | 2009-02-23 00:00:00
Closed | 66 | 2 | 2009-02-23 00:00:00
Closed | 66 | 2 | 2009-02-23 00:00:00
Closed | 66 | 2 | 2009-02-23 00:00:00
Closed | 65 | 2 | 2009-02-24 00:00:00
Closed | 65 | 2 | 2009-02-24 00:00:00
Closed | 50 | 2 | 2009-03-11 00:00:00
Closed | 65 | 2 | 2009-02-24 00:00:00
Closed | 65 | 3 | 2009-02-24 00:00:00
Closed | 65 | 3 | 2009-02-24 00:00:00
Closed | 65 | 2 | 2009-02-24 00:00:00
Closed | 64 | 2 | 2009-02-25 00:00:00
Closed | 64 | 2 | 2009-02-25 00:00:00
Closed | 64 | 2 | 2009-02-25 00:00:00
Closed | 64 | 3 | 2009-02-25 00:00:00
Closed | 29 | 2 | 2009-04-01 00:00:00
Closed | 43 | 2 | 2009-03-18 00:00:00
Open | 64 | 2 | 2009-02-25 00:00:00
Closed | 64 | 3 | 2009-02-25 00:00:00
Closed | 64 | 2 | 2009-02-25 00:00:00
Closed | 64 | 3 | 2009-02-25 00:00:00
Closed | 64 | 3 | 2009-02-25 00:00:00
Closed | 64 | 3 | 2009-02-25 00:00:00
Closed | 64 | 3 | 2009-02-25 00:00:00
Closed | 64 | 3 | 2009-02-25 00:00:00
Closed | 64 | 2 | 2009-02-25 00:00:00
Closed | 63 | 2 | 2009-02-26 00:00:00
Closed | 63 | 2 | 2009-02-26 00:00:00
Open | 37 | 2 | 2009-03-24 00:00:00
Open | 21 | 2 | 2009-04-09 00:00:00
 |  | Sev 1 | sev 2 | Sev 3
 | 0-10 days |  | 0
 | 11-20 days |  | 0
 | 21-30 days |  | 0
 | >30 days |  | 0
 |  |  |  |  | The issues I am facing
 |  |  |  |  | I thought there was leading blank space in Column A in some cells
 |  |  |  |  | Age is calculated by a formula within that cell
 |  |  |  |  | tried array formula also by pressing Ctrl+Shift+Enter