Spreadsheet: 152447d1335384247-excel-2007-return-value-if-four-criteria-are-met-lookup-if-four-criteria-are-met
Sheet: Sheet1

 |  |  |  |  |  | REPORTING PERIOD: |  |  | 2012-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-01 00:00:00 |  |  |  |  |  |  | 2012-02-01 00:00:00 |  |  |  |  |  |  | 2012-03-01 00:00:00 |  |  |  |  |  |  | 2012-04-01 00:00:00 | 2012-04-01 00:00:00 | 2012-04-01 00:00:00 | 2012-04-01 00:00:00 | 2012-04-01 00:00:00 | 2012-04-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-05-01 00:00:00 | 2012-05-01 00:00:00 | 2012-05-01 00:00:00 | 2012-05-01 00:00:00 | 2012-05-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-06-01 00:00:00 | 2012-06-01 00:00:00 | 2012-06-01 00:00:00 | 2012-06-01 00:00:00 | 2012-06-01 00:00:00 | 2012-06-01 00:00:00
 | l | m | n/a | o | p | q | Total | l | m | n/a | o | p | q | Total | l | m | n | o | p | q | Total |  |  |  | l | m | n | o | p | q | Total | l | m | n | o | p | q | Total | l | m | n | o | p | q | Total | l | m | n | o | p | q | Total | l | m | n | o | p | q | Total | l | m | n | o | p | q | Total
All |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All | 50 | 13 | 46 | 31 | 22 | 8 |  | 35 | 9 | 57 | 39 | 16 | 5 |  | 43 | 7 | 49 | 45 | 15 | 10
d related |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d related | 22 | 2 | 31 | 7 | 14 | 1 |  | 28 | 1 | 40 | 8 | 10 | 1 |  | 29 | 2 | 37 | 13 | 2 | 8
D Related % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D Related %
x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | 1 | 1 | 6 | 6 | 10 |  |  | 6 |  | 9 | 5 | 8 | 1 |  | 8 | 2 | 17 | 4 | 1 | 6
x  % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x  %
CYTD Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CYTD Totals
County A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | County A | 45 | 16 | 64 | 30 | 25 | 9 |  | 32 | 12 | 47 | 41 | 18 | 6 |  | 43 | 7 | 49 | 45 | 15 | 10
d related |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | d related | 21 | 7 | 33 | 9 | 13 | 5 |  | 27 | 0 | 35 | 9 | 9 | 1 |  | 29 | 2 | 37 | 13 | 2 | 8
D Related % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D Related %
x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | 2 |  | 5 | 8 | 11 | 5 |  | 7 |  | 10 | 7 | 7 |  |  | 8 | 2 | 17 | 4 | 1 | 6
x  % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x  %
CYTD Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CYTD Totals
 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 0 | 1 | 2 | 3 | 4 | 5 | 6
 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | Put value in B16 if four criteria in the range Y7:BO20 are met
 | * | County A
 | * | d related
 | * | l
 | * | 2012-01-01 00:00:00
 | 2012-01-01 00:00:00
 | l | m | n | o | p | q | Total
All | 50 | 13 | 46 | 31 | 22 | 8
d related | 22 | 2 | 31 | 7 | 14 | 1
D Related %
x | 1 | 1 | 6 | 6 | 10
x  %
CYTD Totals
County A | 45 | 16 | 64 | 30 | 25 | 9
d related | 21 | 7 | 33 | 9 | 13 | 5
D Related %
x | 2 |  | 5 | 8 | 11 | 5
x  %
CYTD Totals