Spreadsheet: 275139d1383341257-how-to-display-value-based-on-selection-array-totals_test
Sheet: Sheet1

 |  | Want This (or something simular) |  |  | Currently have this:
 |  | Start | Finish |  | Select Report
 |  | 2013-06-01 00:00:00 | 2013-08-01 00:00:00 |  | 12 Month Report |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reference Sheet Name: |  |  |  | Reference Sheet Name: |  |  |  | Reference Sheet Name: |  |  |  | Reference Sheet Name:
 |  |  |  |  |  |  |  |  | 2013-05-01 00:00:00 |  |  |  | 2013-06-01 00:00:00 |  |  |  | 2013-07-01 00:00:00 |  |  |  | 2013-07-01 00:00:00 |  |  |  | 2013-08-01 00:00:00 |  |  |  | 2013-09-01 00:00:00 |  |  |  | 2013-10-01 00:00:00 |  |  |  | May 2013 PM Report1.xlsm |  |  |  | May 2013 PM Report1.xlsm |  |  |  | May 2013 PM Report1.xlsm |  |  |  | May 2013 PM Report1.xlsm |  |  |  | May 2013 PM Report1.xlsm
 | OME | Ports | Facility/CID |  | Insident Counts |  |  |  | Total Counts (Values) |  |  |  | Total Counts (Values) |  |  |  | Total Counts (Values) |  |  |  | Total Counts (Values) |  |  |  | Total Counts (Values) |  |  |  | Total Counts (Values) |  |  |  | Total Counts (Values) |  |  |  | Total Counts |  |  |  | Total Counts |  |  |  | Total Counts |  |  |  | Total Counts |  |  |  | Total Counts
 |  |  |  |  | [NAME] | ES | SES | UAS | [NAME] | ES | SES | UAS | [NAME] | ES | SES | UAS | [NAME] | ES | SES | UAS | [NAME] | ES | SES | UAS | [NAME] | ES | SES | UAS | [NAME] | ES | SES | UAS | [NAME] | ES | SES | UAS | [NAME] | ES | SES | UAS | [NAME] | ES | SES | UAS | [NAME] | ES | SES | UAS | [NAME] | ES | SES | UAS | [NAME] | ES | SES | UAS
 |  |  |  |  | CV-OTU | ES-OTU | SES-OTU | SEFS-OTU | CV-OTU | ES-OTU | SES-OTU | SEFS-OTU | CV-OTU | ES-OTU | SES-OTU | SEFS-OTU | CV-OTU | ES-OTU | SES-OTU | SEFS-OTU | CV-OTU | ES-OTU | SES-OTU | SEFS-OTU | CV-OTU | ES-OTU | SES-OTU | SEFS-OTU | CV-OTU | ES-OTU | SES-OTU | SEFS-OTU | CV-OTU | ES-OTU | SES-OTU | SEFS-OTU | CV-OTU | ES-OTU | SES-OTU | SEFS-OTU | CV-OTU | ES-OTU | SES-OTU | SEFS-OTU | CV-OTU | ES-OTU | SES-OTU | SEFS-OTU | CV-OTU | ES-OTU | SES-OTU | SEFS-OTU | CV-OTU | ES-OTU | SES-OTU | SEFS-OTU
 | ANCHO-ROC-OME1
ANCHO-ROC-OME1-OC192-1-5-1 | ANCHO-ROC-OME1 | OC192-1-5-1 | 9PM01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0
ANCHO-ROC-OME1-OC192-1-6-1 | ANCHO-ROC-OME1 | OC192-1-6-1 | 9PM05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ANCHO-ROC-OME1-OC192-1-9-1 | ANCHO-ROC-OME1 | OC192-1-9-1 | 9PP03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ANCHO-ROC-OME1-OC192-1-10-1 | ANCHO-ROC-OME1 | OC192-1-10-1 | 9PP02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
ANCHO-ROC-OME1-OC192-1-13-1 | ANCHO-ROC-OME1 | OC192-1-13-1 | 9DD13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
ANCHO-ROC-OME1-OC192-1-14-1 | ANCHO-ROC-OME1 | OC192-1-14-1 | 9DD14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
ANCHO-ROC-OME1-OTM2-1-10-1 | ANCHO-ROC-OME1 | OTM2-1-10-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
ANCHO-ROC-OMEBB1- | ANCHO-ROC-OMEBB1
ANCHO-ROC-OMEBB1-OC48-1-3-2 | ANCHO-ROC-OMEBB1 | OC48-1-3-2 | CVTA1RR
ANCHO-ROC-OMEBB1-OC48-1-3-3 | ANCHO-ROC-OMEBB1 | OC48-1-3-3 | CVTA2RR
ANCHO-ROC-OMEBB1-OC48-1-9-2 | ANCHO-ROC-OMEBB1 | OC48-1-9-2 | CVTA1RR
ANCHO-ROC-OMEBB1-OC48-1-9-3 | ANCHO-ROC-OMEBB1 | OC48-1-9-3 | CVTA2RR