Spreadsheet: 799027d1664884640-countifs-and-different-dates-excel-risks
Sheet: Sheet1

RiskID | Release? | Status | OwnerWorkStream | Impact | Probability | RiskScore | PlannedClosureDate | Raised Date | Sign-off status | Requirement Type | Impacted Milestone | Item Type
409 | R1 | Open | Training | 2-TANGIBLE | 3-POSSIBLE | 6 | 2022-09-15 00:00:00 | 2022-08-02 00:00:00 |  | NFR |  | Item
407 | R2 | Open | O2C | 5-MAJOR | 3-POSSIBLE | 15 | 2022-12-31 00:00:00 | 2022-08-02 00:00:00 |  | n/a |  | Item
406 | R1a | Open | Training | 2-TANGIBLE | 3-POSSIBLE | 6 | 2022-10-03 00:00:00 | 2022-08-01 00:00:00 |  | NFR |  | Item
405 | R1 | Open | Training | 3-CONSEQUENTIAL | 3-POSSIBLE | 9 | 2022-09-15 00:00:00 | 2022-07-29 00:00:00 |  | Functional |  | Item
404 | R2 | Open | B2B | 5-MAJOR | 3-POSSIBLE | 15 | 2022-09-01 00:00:00 | 2022-07-28 00:00:00 |  | n/a |  | Item
399 | R1 | Open | Training | 4-SIGNIFICANT | 4-LIKELY | 16 | 2022-09-15 00:00:00 | 2022-07-26 00:00:00 |  | NFR |  | Item
397 | R1 | Open | Reporting | 4-SIGNIFICANT | 3-POSSIBLE | 12 | 2022-09-16 00:00:00 | 2022-07-26 00:00:00 |  | n/a |  | Item
394 | R2 | Open | P2P | 4-SIGNIFICANT | 4-LIKELY | 16 | 2022-09-30 00:00:00 | 2022-07-14 00:00:00 |  | n/a |  | Item
392 | R2 | Open | eSOC | 4-SIGNIFICANT | 3-POSSIBLE | 12 | 2022-09-12 00:00:00 | 2022-07-04 00:00:00 |  | n/a |  | Item
391 | R1 | Open | Reporting | 4-SIGNIFICANT | 4-LIKELY | 16 | 2022-09-22 00:00:00 | 2022-07-01 00:00:00 |  | NFR |  | Item
389 | R2 | Open | B2B | 3-CONSEQUENTIAL | 4-LIKELY | 12 | 2022-09-26 00:00:00 | 2022-06-28 00:00:00 |  | n/a |  | Item
383 | R1 | Open | Reporting | 4-SIGNIFICANT | 4-LIKELY | 16 | 2022-09-21 00:00:00 | 2022-05-31 00:00:00 |  | NFR |  | Item
382 | R2 | Open | Testing | 4-SIGNIFICANT | 3-POSSIBLE | 12 | 2022-05-17 00:00:00 | 2022-05-17 00:00:00 |  | n/a |  | Item
379 | R1 | Open | OCM | 3-CONSEQUENTIAL | 4-LIKELY | 12 | 2022-06-03 00:00:00 | 2022-05-12 00:00:00 |  | n/a |  | Item
377 | R2 | Open | Testing | 4-SIGNIFICANT | 3-POSSIBLE | 12 | 2022-06-03 00:00:00 | 2022-05-10 00:00:00 |  | n/a |  | Item
373 | R1a | Open | Data | 5-MAJOR | 3-POSSIBLE | 15 | 2022-08-18 00:00:00 | 2022-05-05 00:00:00 |  | n/a |  | Item
359 | R2 | Open | Transition | 3-CONSEQUENTIAL | 3-POSSIBLE | 9 | 2022-07-29 00:00:00 | 2022-03-18 00:00:00 |  | n/a |  | Item
357 | R2 | Open | LRS | 3-CONSEQUENTIAL | 4-LIKELY | 12 | 2022-05-11 00:00:00 | 2022-03-15 00:00:00 |  |  |  | Item
356 | R2 | Open | LRS | 4-SIGNIFICANT | 4-LIKELY | 16 | 2022-04-29 00:00:00 | 2022-03-15 00:00:00 |  | n/a |  | Item
354 | R2 | Open | Reporting | 3-CONSEQUENTIAL | 4-LIKELY | 12 | 2022-10-31 00:00:00 | 2022-03-10 00:00:00 |  | n/a |  | Item
350 | R2 | Open | Manhattan (Technical & Operations) | 4-SIGNIFICANT | 3-POSSIBLE | 12 | 2022-09-05 00:00:00 | 2022-02-25 00:00:00 |  | n/a |  | Item
339 | R2 | Open | Reporting | 4-SIGNIFICANT | 4-LIKELY | 16 | 2022-05-26 00:00:00 | 2022-02-10 00:00:00 |  | n/a |  | Item
287 | R2 | Open | O2C | 5-MAJOR | 3-POSSIBLE | 15 | 2022-09-30 00:00:00 | 2021-11-08 00:00:00 |  | n/a |  | Item
268 | R2 | Open | O2C | 3-CONSEQUENTIAL | 3-POSSIBLE | 9 | 2022-10-31 00:00:00 | 2021-10-20 00:00:00 |  | n/a |  | Item
258 | R3 | Open | Manhattan (Technical & Operations) | 4-SIGNIFICANT | 4-LIKELY | 16 | 2022-06-30 00:00:00 | 2021-09-22 00:00:00 |  | n/a |  | Item
227 | R2 | Open | B2B | 4-SIGNIFICANT | 4-LIKELY | 16 | 2022-07-29 00:00:00 | 2021-08-02 00:00:00 |  | n/a |  | Item
225 | R2 | Open | O2C | 4-SIGNIFICANT | 2-UNLIKELY | 8 | 2022-09-16 00:00:00 | 2021-07-30 00:00:00 |  | Functional |  | Item
 |  |  | I need to be able to calculate how many of the risks are passed their due date and have a Risk Score of more than 20
 |  |  | and
 |  |  | I need to be able to calculate how many of the risks are not passed their due date and have a risk score of more than 20