I was wondering if anyone could assist me with an excel problem.

I have a table in one worksheet that details health and safety incidents. The data captured includes:


Column A: Date of Incident

Column B: Category of Incident – Cat 1 = slip, trip or fall, cat 2 = physical assault and so on up to cat 10.

Column C: Summary


On a separate worksheet I have a table split by month across the top (Jan-Dec columns B:M) and Category 1-10 down column A (A2:A11). This table drives graphs that detail occurrences by month of each type of incident.

I was wondering if there is a way to count the number of times each category occurs between date ranges that will automatically populate the table that drives the graphs?

I was thinking that a countif formula within the table would be the best solution with the formula amended in each row and column to reflect month and category.

Any assistance would be greatly received