Count Safety Incidents by Site
I need to count the number of safety reports logged for 'Site A' to monitor compliance.
=COUNTIF(B2:B7,"Site A") How it works: The COUNTIF function counts cells within a specified range that meet a given criterion. In this scenario, it counts every row in the 'Site' column (B2:B7) where the site name is exactly 'Site A', providing a quick tally of incidents for that specific location. This helps in monitoring site-specific safety performance.
Data Setup
| "Report ID" | "Site" | "Incident Type" | "Date" |
|---|---|---|---|
| "1001" | "Site A" | "Fall" | "2023-01-15" |
| "1002" | "Site B" | "Equipment Malfunction" | "2023-01-16" |
| "1003" | "Site A" | "Near Miss" | "2023-01-17" |
| "1004" | "Site C" | "Injury" | "2023-01-18" |
| "1005" | "Site A" | "Fall" | "2023-01-19" |
| "1006" | "Site B" | "Near Miss" | "2023-01-20" |
Step-by-Step Guide
Open your safety incident log in Excel.
Identify the column containing the 'Site' information (e.g., Column B).
In an empty cell where you want the result, type the formula: `=COUNTIF(B2:B7,"Site A")`
Press Enter to see the total count of incidents specifically for 'Site A'.
Explore More
Flag Budget Overruns for Materials
I want a formula that displays 'Over Budget' if the actual material cost exceeds the estimated cost, otherwise 'Within Budget'.
Get Material Cost per Unit
I need to pull the unit cost for 'Concrete' and 'Lumber' from a vendor price list into my estimation sheet.
Calculate Total Hours by Subcontractor
I want to sum the total billable hours worked by the 'Plumbing' subcontractor across all project days.
Find Supplier Contact by Material
I need to find the phone number of the supplier who provides 'Drywall', searching through a messy vendor list.