Help with cross cell referencing

AmandaHore

I have a sheet of incidents that I want to be able to count the number of certain types in a month.

In my incident sheet I have

a column called "Type of Incident", that has values of Safety, Environment and Quality

A column for the date, that I have used formulas in helper columns to get the Month and year. So now a cell called Month/Year that has values like January 2025, December 2024 etc. There are a lot of columns in-between these.

I can count the number of each type of incident using:

=COUNTIF([Type of Issue]1:[Type of Issue]25, "Safety")

I want to end up with a table that looks like the below so that I can then turn it into a chart.

I have created a new sheet to build this table.

	Safety	Quality	Environment
January 2025	3	2	0
December 2024	1	6	0

I have got the count working referencing the other sheet. (called Incident)

When I go to just count those where the type is safety for January my formula does not work. I am using 'reference other sheets' but have just picked the column I want in the range.

=IF({Incident Range 2} = [Primary Column]@row, COUNTIF({incident Range 3}, HAS(@cell, "Safety")))

How do I structure the 'Incident' Sheet and also the formula to get what I need?