K
KH3557
I was wondering if anyone could assist me with an excel problem.
I have a table in one worksheet that details health and safet
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 to
(Jan-Dec columns B:M) and Category 1-10 down column A (A2:A11). Thi
table drives graphs that detail occurrences by month of each type o
incident.
I was wondering if there is a way to count the number of times eac
category occurs between date ranges that will automatically populate th
table that drives the graphs?
I was thinking that a countif formula within the table would be the bes
solution with the formula amended in each row and column to reflec
month and category.
Any assistance would be greatly receive
I have a table in one worksheet that details health and safet
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 to
(Jan-Dec columns B:M) and Category 1-10 down column A (A2:A11). Thi
table drives graphs that detail occurrences by month of each type o
incident.
I was wondering if there is a way to count the number of times eac
category occurs between date ranges that will automatically populate th
table that drives the graphs?
I was thinking that a countif formula within the table would be the bes
solution with the formula amended in each row and column to reflec
month and category.
Any assistance would be greatly receive