Spreadsheet: 150709d1334666760-excel-2007-help-with-getting-text-formulas-to-add-help
Sheet: Use

 | Not submitted | Submitted | Received | Expired / Resubmit | Total
H
B1
B2
B3
B4
B5
B6
Total
F N | MI | R | Pl | Sta | Date | Status
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received |  |  |  |  | Status |  |  |  | Passport Location
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received |  |  |  |  | Not Submitted |  |  |  | w/ Marine
 |  |  | B1 |  |  | Received |  |  |  |  | Submitted |  |  |  | Regiment
 |  |  | B1 |  |  | Received |  |  |  |  | Received |  |  |  | [NAME]
 |  |  | B1 |  |  | Received |  |  |  |  | Expired/Resubmit |  |  |  | In Route to FASTPAC
 |  |  | B1 |  |  | Received |  |  |  |  |  |  |  |  | In Route to Gitmo
 |  |  | B1 |  |  | Received |  |  |  |  |  |  |  |  | Pentagon
 |  |  | B1 |  |  | Received |  |  |  |  |  |  |  |  | DOS
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received |  |  |  |  | Plt
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received |  |  |  |  | B1
 |  |  | B1 |  |  | Received |  |  |  |  | B2
 |  |  | B1 |  |  | Received |  |  |  |  | B3
 |  |  | B1 |  |  | Received |  |  |  |  | B4
 |  |  | B1 |  |  | Received |  |  |  |  | B5
 |  |  | B1 |  |  | Received |  |  |  |  | B6
 |  |  | B1 |  |  | Not Submitted |  |  |  |  | BHQ
 |  |  | B1 |  |  | Received |  |  |  |  | TAD
 |  |  | B1 |  |  | Expired/Resubmit |  |  |  |  | ACP
 |  |  | B1 |  |  | Received |  |  |  |  | RFDF
 |  |  | B1 |  |  | Received |  |  |  |  | PCS
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Expired/Resubmit
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B1 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Not Submitted
 |  |  | B2 |  |  | Expired/Resubmit
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Expired/Resubmit
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Expired/Resubmit
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Expired/Resubmit
 |  |  | B2 |  |  | Not Submitted
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Expired/Resubmit
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Not Submitted
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Not Submitted
 |  |  | B2 |  |  | Not Submitted
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B2 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Expired/Resubmit
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Submitted
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Expired/Resubmit
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Expired/Resubmit
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Not Submitted
 |  |  | B3 |  |  | Received
 |  |  | B3 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Submitted
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Expired/Resubmit
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Submitted
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Expired/Resubmit
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Submitted
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Submitted
 |  |  | B4 |  |  | Submitted
 |  |  | B4 |  |  | Submitted
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Expired/Resubmit
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Submitted
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Submitted
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Submitted
 |  |  | B4 |  |  | Submitted
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Not Submitted
 |  |  | B4 |  |  | Received
 |  |  | B4 |  |  | Expired/Resubmit
 |  |  | B4 |  |  | Expired/Resubmit
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Not Submitted
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Not Submitted
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Not Submitted
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Not Submitted
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Submitted
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Submitted
 |  |  | B5 |  |  | Not Submitted
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Submitted
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Submitted
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Not Submitted
 |  |  | B5 |  |  | Received
 |  |  | B5 |  |  | Submitted
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Submitted
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Submitted
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Submitted
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Submitted
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Submitted
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Received
 |  |  | B6 |  |  | Expired/Resubmit
 |  |  | B6 |  |  | Received
 |  |  | BHQ |  |  | Not Submitted
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Not Submitted
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Not Submitted
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Not Submitted
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Not Submitted
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Not Submitted
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Not Submitted
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Not Submitted
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Not Submitted
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Not Submitted
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Not Submitted
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Not Submitted
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Not Submitted
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Not Submitted
 |  |  | BHQ |  |  | Not Submitted
 |  |  | BHQ |  |  | Not Submitted
 |  |  | BHQ |  |  | Received
 |  |  | BHQ |  |  | Received
 |  |  | TAD |  |  | Received
 |  |  | TAD |  |  | Received
 |  |  | TAD |  |  | Received
 |  |  | TAD |  |  | Received
 |  |  | TAD |  |  | Received
 |  |  | TAD |  |  | Received
 |  |  | TAD |  |  | Received
 |  |  | TAD |  |  | Not Submitted
 |  |  | TAD |  |  | Received
 |  |  | TAD |  |  | Received
 |  |  | TAD |  |  | Submitted
 |  |  | TAD |  |  | Not Submitted
 |  |  | TAD |  |  | Received
 |  |  | TAD |  |  | Received
 |  |  | TAD |  |  | Received
 |  |  | TAD |  |  | Received
 |  |  | TAD |  |  | Received
 |  |  | TAD |  |  | Not Submitted
 |  |  | TAD |  |  | Not Submitted
 |  |  | TAD |  |  | Not Submitted
 |  |  | TAD |  |  | Received