Spreadsheet: 92751d1292310529-using-countifs-on-entries-in-multiple-columns-pm-chart-trial
Sheet: 2010 PM

 |  |  | Spot PM Dates
PRESS | DIE | BP or TR | 1 | 1 | 2 | 2 | 1 | 2 | 3 | 1 | 2 | 4 | 1 | 2 | 5 | 1 | 2 | 6 | 1 | 2 | 7 | 1 | 2 | 8 | 1 | 2 | 9 | 1 | 2 | 10 | 1 | 2 | 11 | 1 | 2 | 12 | 1 | 2 | 13 | 1 | 2 | 14 | 1 | 2 | 15 | 1 | 2
2-1 | Multi-Blanker
2-1 | 42111-02070-BL |  | 2010-09-07 00:00:00 | x
 | 42111-02070-00 |  | 2010-03-01 00:00:00 | x |  | 2010-07-09 00:00:00 |  | x | 2010-07-29 00:00:00 |  | x | 2010-08-06 00:00:00 |  | x | 2010-08-18 00:00:00 |  | x | 2010-08-25 00:00:00 |  | x | 2010-08-26 00:00:00 | x |  | 2010-11-29 00:00:00 | x |  | 2010-12-08 00:00:00 |  | x
 | 42111-08030-00 |  | 2010-03-27 00:00:00 | x | x
 | 42313-08040-T1
2-1 | 42313/4-08040/30-BL |  | 2010-04-28 00:00:00 | x
2-1 | 46212-TE009-T1
2-1 | 46212-TE011-T1 |  | 2010-02-24 00:00:00 | x
 | 48232-08020-T1 |  | 2010-07-22 00:00:00 | x |  | 2010-07-29 00:00:00 | x
2-1 | 48232/3-08020-BL |  | 2010-10-08 00:00:00 | x
5-2 | 48514-0C010-BL
5-1 | 48514-0C010-T1 |  | 2010-07-22 00:00:00 | x |  | 2010-08-13 00:00:00 | x |  | 2010-09-02 00:00:00 | x |  | 2010-09-09 00:00:00 | x
5-2 | 48515-0C010-BL
5-1 | 48515-0C010-T1 |  | 2010-06-23 00:00:00 | x
2-1 | 48621/2-0C010-BL |  | 2009-11-12 00:00:00 | x
2-1 | 48621/4-08030-BL
 | 48621-08030-00 |  | 2010-05-06 00:00:00 |  | x
 | 48621-0C010-T1 |  | 2010-05-27 00:00:00 |  | x | 2010-06-29 00:00:00 | x |  | 2010-08-11 00:00:00 | x | x
 | 48622-08030-00 |  | 2010-04-06 00:00:00 | x | x | 2010-07-02 00:00:00 |  | x | 2010-07-27 00:00:00 |  | x
 | 48622-0C010-T1 |  | 2010-03-29 00:00:00 | x |  | 2010-04-13 00:00:00 |  | x | 2010-09-25 00:00:00 |  | x
2-1 | 48622/3-08030-BL
2-1 | 48623/4-0C020-BL
 | 48623-08030-00 |  | 2010-02-24 00:00:00 | x | x
 | 48623-0C020-T1 |  | 2010-02-20 00:00:00 | x |  | 2010-03-05 00:00:00 |  | x | 2010-08-18 00:00:00 |  | x | 2010-10-06 00:00:00 | x | x
 | 48624-08030-00 |  | 2010-04-06 00:00:00 | x | x | 2010-09-07 00:00:00 | x
 | 48624-0C020-T1 |  | 2009-12-07 00:00:00 | x |  | 2010-08-17 00:00:00 | x
2-1 | 48628-0C010-T1 |  | 2010-06-04 00:00:00 | x |  | 2010-08-24 00:00:00 | x
2-1 | 48628-0C020-T1 |  | 2010-03-25 00:00:00 | x |  | 2010-09-09 00:00:00 | x
2-1 | 48711/2-08020-BL |  | 2010-02-22 00:00:00 | x
 | 48711-08010-00 |  | 2010-04-26 00:00:00 |  | x | 2010-07-29 00:00:00 | x |  | 2010-07-30 00:00:00 | x |  | 2010-08-24 00:00:00 | x |  | 2010-08-30 00:00:00 |  | x
5-2 | 48733-08010-T1 |  | 2010-03-16 00:00:00 | x |  | 2010-08-10 00:00:00 | x
 | 51145-04010-T1 |  | 2010-03-01 00:00:00 |  | x | 2010-09-23 00:00:00 | x
5-2 | 51151-08010-00 |  | 2010-04-15 00:00:00 | x |  | 2010-07-28 00:00:00 | x
5-2 | 51152-08010-00 |  | 2010-03-25 00:00:00 | x
2-1 | 51158-04020-00 |  | 2010-09-03 00:00:00 | x
2-1 | 51165/6-04010-BL |  | 2009-11-17 00:00:00 | x
 | 51165-04010-T1 |  | 2010-02-19 00:00:00 | x | x
2-1 | 51167-04020-00 |  | 2010-06-30 00:00:00 | x |  | 2010-09-02 00:00:00 | x |  | 2010-11-09 00:00:00 | x
 | 51465-08040-T1 |  | 2010-06-25 00:00:00 | x | x
 | 51466-08040-T1 |  | 2010-03-30 00:00:00 | x | x | 2010-07-30 00:00:00 | x
5-2 | 51761-08010-T1
5-2 | 53211/2-02130-BL
5-1 | 53211-02130-T1 |  | 2010-06-08 00:00:00 | x
5-2 | 53211-08020-T1 |  | 2010-06-24 00:00:00 | x
 | 53213-08020-T1 |  | 2010-06-15 00:00:00 | x | x | 2010-07-09 00:00:00 |  | x | 2010-08-09 00:00:00 |  | x
2-1 | 53213/4-08020-BL |  | 2010-08-24 00:00:00 | x
5-2 | 53215-02120-BL |  | 2010-03-11 00:00:00 | x
5-1 | 53215-02120-T1 |  | 2010-06-10 00:00:00 | x |  | 2010-07-28 00:00:00 | x |  | 2010-11-11 00:00:00 | x
 | 53216-08030-T1 |  | 2010-06-06 00:00:00 | x | x | 2010-10-15 00:00:00 |  | x
5-2 | 53228-08010-T1
5-2 | 53229-08010-T1
5-2 | 53268-08020-T1 |  | 2010-04-28 00:00:00 | x
5-2 | 53273-08010-T1 |  | 2010-03-22 00:00:00 | x
2-1 | 53725-0C010-T1
2-1 | 53731-08030-T1 |  | 2010-05-21 00:00:00 | x
5-2 | 53741-08020-T1 |  | 2010-06-23 00:00:00 | x
 | 53776-08030-T1 |  | 2010-02-11 00:00:00 |  | x | 2010-08-10 00:00:00 |  | x
5-2 | 53776/7-08030-BL
5-2 | 53837-08010-T1
5-2 | 53838-08020-T1 |  | 2010-09-03 00:00:00 | x
5-1 | 55112-08020-T1
5-2 | 55133/4-0C020-BL
5-1 | 55133-0C020-T1 |  | 2010-04-27 00:00:00 | x |  | 2010-09-03 00:00:00 | x
2-1 | 55171-04020-T1 |  | 2010-05-17 00:00:00 | x
2-1 | 55171-08030-T1 |  | 2010-04-30 00:00:00 | x |  | 2010-08-11 00:00:00 | x
2-1 | 55171-0C010-T1 |  | 2010-06-08 00:00:00 | x |  | 2010-07-26 00:00:00 | x
2-1 | 55171-0E020-T1 |  | 2010-02-22 00:00:00 | x |  | 2010-08-02 00:00:00 | x |  | 2010-08-05 00:00:00 | x
5-2 | 55172-0E010-T1 |  | 2010-04-23 00:00:00 | x |  | 2010-09-22 00:00:00 | x
5-2 | 55178-0E020-T1
5-1 | 55179-08010-T1 |  | 2010-03-05 00:00:00 | x
5-2 | 55179-08010-BL
5-2 | 55194-0E020-T1 |  | 2010-03-30 00:00:00 | x
2-1 | 55712-08040-BL
 | 55712-08040-T1 |  | 2010-05-12 00:00:00 | x |  | 2010-05-26 00:00:00 |  | x | 2010-09-02 00:00:00 | x
5-1 | 55715-08010-T1 |  | 2010-07-09 00:00:00 | x |  | 2010-08-09 00:00:00 | x
 | 55717-08050-T1 |  | 2010-08-06 00:00:00 | x | x
2-1 | 55717/8-08050/40-BL
5-2 | 55725-08030-T1 |  | 2010-07-06 00:00:00 | x
5-2 | 55731-08020-T1 |  | 2010-01-19 00:00:00 | x
 | 55741-08010-T1 |  | 2010-04-22 00:00:00 | x | x | 2010-05-05 00:00:00 | x |  | 2010-08-06 00:00:00 | x | x | 2010-08-15 00:00:00 | x | x | 2010-09-25 00:00:00 | x |  | 2010-11-11 00:00:00 | x
5-2 | 55743-08030-T1 |  | 2010-03-02 00:00:00 | x
2-1 | 55745-08020-T1 |  | 2010-07-07 00:00:00 | x
 | 55746-08020-T1 |  | 2010-02-25 00:00:00 | x |  | 2010-11-30 00:00:00 | x
2-1 | 55746-08020-BL
5-2 | 55747-08030-T1 |  | 2010-04-21 00:00:00 | x |  | 2010-08-12 00:00:00 | x
5-2 | 55747-0C010-BL |  | 2010-05-10 00:00:00 | x
5-1 | 55747-0C010-T1 |  | 2010-06-22 00:00:00 | x |  | 2010-07-27 00:00:00 | x |  | 2010-08-18 00:00:00 | x |  | 2010-09-07 00:00:00 | x
5-2 | 55795-08010-T1
2-1 | 57113-0E010-T1 |  | 2010-07-28 00:00:00 | x |  | 2010-08-05 00:00:00 | x |  | 2010-08-10 00:00:00 | x
2-1 | 57113-08020-T1
 | 57115-0E020-T1 |  | 2010-06-09 00:00:00 |  | x
5-2 | 57117/8-0E010-BL |  | 2010-04-02 00:00:00 | x |  | 2010-07-07 00:00:00 | x
 | 57117-0E010-T1 |  | 2010-09-17 00:00:00 | x | x
5-2 | 57147-0E050-T1 |  | 2010-07-22 00:00:00 | x |  | 2010-08-18 00:00:00 | x
2-1 | 57161-08020-T1 |  | 2010-10-07 00:00:00 | x
 | 57162-0E010-BL
 | 57162-0E010-T1 |  | 2010-04-14 00:00:00 | x | x | 2010-08-17 00:00:00 | x | x
2-1 | 57165-08010-T1 |  | 2010-05-18 00:00:00 | x
 | 57169-08030-T1 |  | 2010-04-02 00:00:00 |  | x | 2010-04-26 00:00:00 | x |  | 2010-07-27 00:00:00 |  | x
 | 57217-0C040-T1 |  | 2010-01-06 00:00:00 | x | x
5-2 | 57218/9-02020/50-BL |  | 2010-04-19 00:00:00 | x |  | 2010-09-15 00:00:00 | x |  | 2010-09-16 00:00:00 | x
5-1 | 57218-02020-00 |  | 2009-10-27 00:00:00 | x |  | 2010-08-27 00:00:00 | x
5-2 | 57311/2-08010-BL |  | 2010-02-19 00:00:00 | x
 | 57311-08010-T1 |  | 2010-11-09 00:00:00 |  | x
 | 57313-08010-T1 |  | 2010-02-19 00:00:00 | x |  | 2010-08-04 00:00:00 | x
5-2 | 57315/6-08010-BL |  | 2010-08-02 00:00:00 | x
5-1 | 57315-08010-T1 |  | 2010-03-11 00:00:00 | x |  | 2010-08-11 00:00:00 | x |  | 2010-08-12 00:00:00 | x |  | 2010-09-20 00:00:00 | x
5-2 | 57317/8-08010-BL
5-1 | 57317-08010-T1 |  | 2010-06-14 00:00:00 | x
5-2 | 57337-08010-T1
 | 57413-08020-T1 |  | 2010-07-02 00:00:00 | x |  | 2010-09-16 00:00:00 | x |  | 2010-12-10 00:00:00 |  | x
2-1 | 57427-08020-T1 |  | 2010-02-19 00:00:00 | x
2-1 | 57428-08020-T1 |  | 2010-03-06 00:00:00 | x
 | 57451-0E040-T1 |  | 2010-05-25 00:00:00 | x
 | 57451-08020-T1 |  | 2010-03-29 00:00:00 | x
 | 57471-0E030-T1 |  | 2010-03-23 00:00:00 | x
2-1 | 57475-08020-T1
 | 57478-08010-T1 |  | 2010-03-30 00:00:00 | x | x
2-1 | 57478-08010-BL
 | 57479-08010-T1 |  | 2010-03-02 00:00:00 |  | x
2-1 | 57486-0C020-T1 |  | 2010-08-30 00:00:00 | x |  | 2010-09-07 00:00:00 | x
 | 57533-0E030-T1 |  | 2010-03-15 00:00:00 |  | x
2-1 | 57615/6-0E040-BL
 | 57615-0E040-T1 |  | 2010-03-09 00:00:00 |  | x | 2010-07-29 00:00:00 | x | x | 2010-09-30 00:00:00 | x | x
5-2 | 57621/2-08010-BL
5-1 | 57621-08010-T1
5-1 | 57622-08010-T1
5-2 | 57628/9-0E010-BL
5-1 | 57628-0E010-T1 |  | 2010-01-29 00:00:00 | x
5-2 | 57635-0E010-T1 |  | 2009-10-31 00:00:00 | x |  | 2010-07-30 00:00:00 | x |  | 2010-08-05 00:00:00 | x
5-2 | 57639-08010-T1
 | 57652-08030-T1 |  | 2010-08-30 00:00:00 |  | x | 2010-09-21 00:00:00 |  | x
2-1 | 57652-08030-BL |  | 2010-08-05 00:00:00 | x |  | 2010-09-20 00:00:00 | x
 | 57653-08020-T1 |  | 2010-07-08 00:00:00 | x |  | 2010-07-30 00:00:00 |  | x | 2010-08-27 00:00:00 | x | x
5-2 | 57663-08020-T1 |  | 2009-11-18 00:00:00 | x
 | 57663-0E040-T1 |  | 2010-06-17 00:00:00 | x |  | 2010-07-08 00:00:00 |  | x
5-2 | 57664-08020-T1 |  | 2009-12-03 00:00:00
5-2 | 57675-08010-T1 |  | 2010-12-02 00:00:00 | x | x
5-2 | 57686-08020-T1
2-1 | 57688-0C030-T1
2-1 | 57688/9-0E020-BL
 | 57688-0E020-T1 |  | 2010-05-22 00:00:00 | x |  | 2010-08-30 00:00:00 |  | x
5-2 | 57689-08020-T1 |  | 2010-02-13 00:00:00 | x
5-2 | 57755-08010-T1 |  | 2010-07-02 00:00:00 | x
2-1 | 57791/2-08010-BL
 | 57791-08011-T1
5-2 | 57795-08010-T1 |  | 2010-03-22 00:00:00 | x |  | 2010-08-30 00:00:00 | x
5-2 | 57796-08010-T1 |  | 2010-04-06 00:00:00 | x
2-1 | 57832-0E040-T1
 | 58115-0E040-T1 |  | 2010-01-26 00:00:00 |  | x | 2010-08-19 00:00:00 |  | x | 2010-08-30 00:00:00 | x | x
 | 58116-08010-T1 |  | 2010-06-24 00:00:00 | x |  | 2010-04-15 00:00:00 |  | x
 | 58212-0E040-T1 |  | 2010-08-15 00:00:00 | x | x | 2010-09-15 00:00:00 | x | x
2-1 | 58213-0C040-BL |  | 2010-12-08 00:00:00 | x
 | 58213-0C040-T1 |  | 2010-03-15 00:00:00 |  | x | 2010-04-23 00:00:00 | x |  | 2010-12-08 00:00:00 | x
5-2 | 58215-08010-T1 |  | 2010-03-02 00:00:00 | x
2-1 | 58265-08030-T1 |  | 2010-06-22 00:00:00 | x |  | 2010-08-08 00:00:00 | x
5-2 | 58296-08010-T1 |  | 2010-05-12 00:00:00 | x |  | 2010-07-27 00:00:00 | x
 | 58339-0E030-T1
 | 61145-08030-T1 |  | 2010-04-08 00:00:00 | x |  | 2010-08-02 00:00:00 | x | x | 2010-11-29 00:00:00 | x
2-1 | 61145/6-08030-BL
2-1 | 61211/2-0E040-BL |  | 2010-03-10 00:00:00 | x
 | 61211-0E040-T1 |  | 2010-05-27 00:00:00 | x |  | 2010-08-04 00:00:00 | x |  | 2010-08-24 00:00:00 | x
 | 61213-0E040-T1 |  | 2010-02-24 00:00:00 |  | x | 2010-07-06 00:00:00 | x |  | 2010-08-10 00:00:00 | x |  | 2010-09-21 00:00:00 |  | x
 | 61217-0E020-T1 |  | 2010-08-10 00:00:00 |  | x | 2010-09-01 00:00:00 |  | x
2-1 | 61231-0E030-T1 |  | 2010-04-26 00:00:00 | x |  | 2010-08-02 00:00:00 | x |  | 2010-08-26 00:00:00 | x
2-1 | 61232-0E030-T1 |  | 2010-06-25 00:00:00 | x
 | 61233-0E040-T1 |  | 2010-04-02 00:00:00 |  | x
2-1 | 61321/2-0E040-BL |  | 2010-04-12 00:00:00 | x
 | 61321-0E040-T1 |  | 2010-02-25 00:00:00 | x |  | 2010-08-16 00:00:00 | x | x
 | 61322-0E040-T1 |  | 2010-05-29 00:00:00 | x | x | 2010-09-01 00:00:00 |  | x
 | 61323-0E040-T1 |  | 2010-07-09 00:00:00 |  | x | 2010-08-05 00:00:00 |  | x | 2010-08-27 00:00:00 | x | x | 2010-09-08 00:00:00 |  | x
2-1 | 61343/4-0E040-BL |  | 2010-03-11 00:00:00 | x
 | 61343-0E040-T1 |  | 2009-11-06 00:00:00 | x | x | 2010-08-20 00:00:00 | x
 | 61344-0E040-T1 |  | 2009-10-31 00:00:00 | x | x
 | 61371-0E040-T1 |  | 2010-07-22 00:00:00 | x | x | 2010-09-01 00:00:00 | x |  | 2010-11-29 00:00:00 |  | x
 | 61381-0E040-T1 |  | 2010-05-20 00:00:00 | x | x
 | 61413-0E030-T1 |  | 2010-03-01 00:00:00 | x | x
 | 61415-0E020-T1 |  | 2009-11-12 00:00:00 | x | x | 2010-08-02 00:00:00 |  | x | 2010-08-20 00:00:00 | x | x
 | 61418-0E040-T1 |  | 2010-07-02 00:00:00 | x |  | 2010-12-09 00:00:00 | x
 | 61419-0E040-T1 |  | 2010-08-16 00:00:00 | x
2-1 | 63131-04010-00 |  | 2010-08-24 00:00:00 | x
2-1 | 63132-04040-T1 |  | 2010-03-29 00:00:00 | x |  | 2010-11-23 00:00:00 | x
2-1 | 63132-08020-T1 |  | 2010-03-24 00:00:00 | x |  | 2010-08-05 00:00:00 | x
2-1 | 63132-0C050-T1 |  | 2010-01-24 00:00:00 | x
 | 63135-04061-T1 |  | 2010-03-11 00:00:00 |  | x | 2010-05-28 00:00:00 | x |  | 2010-06-07 00:00:00 | x |  | 2010-11-10 00:00:00 |  | x
5-1 | 63137-08020-T1
2-1 | 64115-04040-T1 |  | 2010-08-12 00:00:00 | x |  | 2010-08-13 00:00:00 | x
2-1 | 64117-04030-T1 |  | 2010-04-18 00:00:00 | x |  | 2010-09-12 00:00:00 | x
5-2 | 68365/9-08020-BL |  | 2010-02-22 00:00:00 | x
5-1 | 68365-08020-T1 |  | 2010-05-10 00:00:00 | x
5-1 | 68369-08020-T1 |  | 2010-03-26 00:00:00 | x