Spreadsheet: 275164d1383357984-how-to-display-value-based-on-selection-array-ef519_totals_test
Sheet: Sheet1

 |  | Want This (or something simular) |  |  | Currently have this:
 |  | Start | Finish |  | Select Report
 |  | 2013-05-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
 |  |  |  |  | $$=IF($F$3="3 Month Report",SUMIFS(AT10:BB10,AT$7:BB$7,F$7),IF($F$3="6 Month Report",SUMIFS(AH10:[NAME]:BB$7,F$7),IF($F$3="9 Month Report",SUMIFS(V10:BB10,V$7:BB$7,F$7),IF($F$3="12 Month Report",SUMIFS(J10:BB10,J$7:BB$7,F$7),IF($F$3="Manual Report",SUMIFS(J10:BB10,J$7:BB$7,F$7,$J$4:$BB$4,">="&$C$3,$J$4:$BB$4,"<="&$D$3),"No Selection")))))
 |  |  |  |  | If you require totals of the incidents,
 |  |  |  |  | copy cell F25 into F10, then remove
 |  |  |  |  | the $$ before the =, then copy across
 |  |  |  |  | into G10:I10, and down to row 23