Hello Everyone!
I am trying to create a formula that counts the number of times a condition is satisfied for each month/year. My sheet has a column "Parameter" that either has the value "OFF" or "ON". I would like to create a formula that counts the number of times "OFF" occurs per month. However, the dates in my data sheet are formatted "13-Nov-2024" for example.
How can I create a formula that counts the numbers of times "OFF" occurs every month/year? I greatly appreciate the help.