I have built a large matrix across multiple sheets to track training data. In the chart, employee names are in the vertical and training activities in the horizontal. Each employee has either a date in a cell (when training occured) or a blank for that cell.

I've used conditional formatting to color in the cells when they are overdue (since the cell shows the training OCCURED, rather than the expiration), but now I want to create a chart for the managers to see (because all managers need charts).

I cannot figure out how to use COUNTIF or COUNTIFS to make it work. No matter how I try to word it, the formula returns no values.