Spreadsheet: 160460d1339089468-i-need-help-with-sumproduct-and-countif-06-04-2012
Sheet: Report Card

FAILED ITEMS - CATEGORY COUNTS
No | Description | Count
1 | Borrower Name | 5
2 | Borrower SSN | 0
3 | Loan Type | 0 |  |  | Team 100
4 | [NAME] | #N/A |  |  | Total Files
5 | Total Loan Amount | #N/A |  |  | [NAME]
6 | Interest Rate | #N/A |  |  | Flags
7 | Occupancy | #N/A
8 | [NAME] | #N/A
9 | Purpose of Loan | #N/A |  |  | Team 200
10 | Property Type | #N/A |  |  | Total Files
11 | LTV & CLTV | #N/A |  |  | [NAME]
12 | Appraised Value | #N/A |  |  | Flags
13 | Sale Price | #N/A
14 | Number of Units | #N/A
15 | Property Address | #N/A |  |  | Team 400
16 | Legal Description | #N/A |  |  | Total Files
17 | Credit Report ID | #N/A |  |  | [NAME]
18 | FICO Score | #N/A |  |  | Flags
19 | FHA Case Number | #N/A
20 | FHA Lender/Originator ID | #N/A |  |  | Team | Branch
21 | Number of REO's | #N/A |  |  | 100 | 220
22 | Employer Name | #N/A |  |  | 100 | 223
23 | Income | #N/A |  |  | 100 | 224
24 | Assets | #N/A |  |  | 100 | 225
25 | Number of Accounts | #N/A |  |  | 100 | 226
26 | Account Numbers | #N/A |  |  | 100 | 227
27 | Paystub Coverage Period | #N/A |  |  | 100 | 228
28 | Census Tract Number | #N/A |  |  | 100 | 229
29 | [NAME] | #N/A |  |  | 100 | 230
30 | Owner of Record | #N/A |  |  | 100 | 233
31 | Borrower Signature on Initial Disclosures | #N/A |  |  | 100 | 234
32 | Borrower Signature Date on Initial Disclosures | #N/A |  |  | 100 | 235
33 | Credit Report Audit Flags | #N/A |  |  | 100 | 236
34 | Loan Safe Audit | #N/A |  |  | 100 | 237
35 | Residential Address check | #N/A |  |  | 100 | 239
36 | Non Arms Length Transaction Check | #N/A |  |  | 100 | 240
37 | Miscellaneous UW Items | #N/A |  |  | 100 | 250
38 | Initial1003 [NAME] | #N/A |  |  | 100 | 306
39 | Other Miscellaneous Items | #N/A |  |  | 100 | 310
40 | Missing Docs | #N/A |  |  | 100 | 354
 |  |  |  |  | 100 | 358
FAILED ITEMS BREAK DOWN |  |  |  |  | 100 | 401
 |  |  |  |  | 100 | 402
 |  |  |  |  | 100 | 403
1 | Borrower(s) Name | 5 |  |  | 100 | 404
A |  | 0 |  |  | 100 | 405
B |  | 0 |  |  | 100 | 406
D |  | 0 |  |  | 100 | 407
E |  | 0 |  |  | 100 | 408
G |  | 0 |  |  | 100 | 409
H |  | 0 |  |  | 100 | 411
I |  | 0 |  |  | 100 | 412
J |  | 0 |  |  | 100 | 421
K |  | 0 |  |  | 100 | 452
M |  | 0 |  |  | 100 | 453
N |  | 0 |  |  | 100 | 536
O |  | 0 |  |  | 100 | 545
P |  | 0 |  |  | 100 | 565
Q |  | 0 |  |  | 100 | 585
R |  | 0 |  |  | 100 | 586
S |  | 0 |  |  | 100 | 591
T |  | 0 |  |  | 100 | 594
W |  | 0 |  |  | 100 | 598
X |  | 0 |  |  | 200 | 100
Y |  | 0 |  |  | 200 | 169
AA |  | 0 |  |  | 200 | 309
AB |  | 0 |  |  | 200 | 316
AC |  | 0 |  |  | 200 | 463
AD |  | 1 |  |  | 200 | 523
AE |  | 0 |  |  | 200 | 525
AF |  | 0 |  |  | 200 | 532
AG |  | 0 |  |  | 200 | 533
AH |  | 0 |  |  | 200 | 535
AI |  | 0 |  |  | 200 | 543
AL |  | 0 |  |  | 200 | 544
AT |  | 0 |  |  | 200 | 553
AU |  | 0 |  |  | 200 | 554
AV |  | 0 |  |  | 200 | 555
AW |  | 0 |  |  | 200 | 562
AX |  | 2 |  |  | 200 | 567
AY |  | 0 |  |  | 200 | 568
AZ |  | 1 |  |  | 200 | 572
BA |  | 0 |  |  | 200 | 584
BB |  | 0 |  |  | 200 | 587
BC |  | 1 |  |  | 200 | 588
BE |  | 0 |  |  | 200 | 589
BF |  | 0 |  |  | 200 | 597
BG |  | 0 |  |  | 200 | 599
BH |  | 0 |  |  | 200 | 601
BI |  | 0 |  |  | 200 | 717
BK |  | 0 |  |  | 200 | 871
BL |  | 0 |  |  | 400 | 231
BM |  | 0 |  |  | 400 | 531
BN |  | 0 |  |  | 400 | 552
BO |  | 0 |  |  | 400 | 718
BQ |  | 0 |  |  | 400 | 719
BR |  | 0 |  |  | 400 | 720
BV |  | 0 |  |  | 400 | 721
CA |  | 0 |  |  | 400 | 800
2 |  | 0 |  |  | 400 | 801
A |  | 0 |  |  | 400 | 802
E |  | 0 |  |  | 400 | 804
I |  | 0 |  |  | 400 | 807
J |  | 0 |  |  | 400 | 815
O |  | 0 |  |  | 400 | 817
AT |  | 0 |  |  | 400 | 821
AU |  | 0 |  |  | 400 | 851
AV |  | 0 |  |  | 400 | 853
AW |  | 0 |  |  | 400 | 855
BB |  | 0 |  |  | 400 | 857
BL |  | 0 |  |  | 400 | 861
BQ |  | 0 |  |  | 400 | 862
3 |  | 0 |  |  | 400 | 863
A |  | 0 |  |  | 400 | 873
B |  | 0