incidents

Hi , In Column B I have dates of incidents . How do I calculate how many incidents were in each month? I tried this =COUNTIF((B2:B1000),"<31/01/2019") Which obviously calculates a range but is there a formula I can use that would just calculate each months incidents?

I am new to Pivot Tables and am having a problem with percentages. I have a Pivot table which looks like this Block Incidents Cumulative Incidents People Cumulative People Percentage Answer should be 1 47 47...

I have a spreadsheet that has numerous entries by individual. The sheet logs all accidents that have taken place on site and I want to be able to provide a summary by individual. I have tried pivot tables but that just shows how many times each individual has an entry. Ideally I would like to...

I was hoping this would be an easy one to solve, but nothing has worked. The basics of what I have setup: 1. I have a query created which displays all records of one field from my main table called 'serious incidents' 2. The query has a running total of the number of records. 3. on a report...

Hi All, I have been amending some code which filters data from various tabs of a master spreadsheet, and copies and pastes these tabs into a new spreadsheet per department. The code I have (admittedly it was existing code which I have been able to manipulate to suit my needs) currently copies...