Inspection tracking template - functions

Aly Ervin

Hello,

I am using the Inspection tracking template and it includes the following function:

=COUNTIFS({MED1}, "No", {Date}, MONTH(@cell ) = $[Month#]@row)

I would like to measure the number of violations per room, rather than per month but I am having difficulty knowing how to change the {Date}, MONTH(@cell ) = $[Month#]@row) part of the function. I would essentially like to make a function that says - count if there is a "No" within a reference, and within the row that has this lab number.