Need help with a formula!

System

This discussion was created from comments split from: Formula - Count by Month and Other Criteria.

Maggie B.

I'm struggling with this formula… I'm trying to get the count for each specific Inspector, for a set date range. In this instance, I would like to know how many inspections Clarence Williams has completed in January 2024.

I have the following formula: =COUNTIFS({NOLA Reporting 11th Floor CE Range 1}], Inspector@row "Clarence Williams", [January 2024 Total]:[January 2024 Total], 1)

heyjay

=COUNTIFS(
Inspector:Inspector, "Clarence Williams", 
[Inspection Date]:[Inspection Date], @cell >= DATE(2024, 1, 1), 
[Inspection Date]:[Inspection Date], @cell <= DATE(2024, 1, 31)
)