4

I want to count how many times "Monday May 14, 2018 5:30-7:30 pm" show up in column A and how many times 1 show up in the same row in column B 

This is what I have but it is not working properly:

=COUNTIFS([Date of Class]:[Date of Class], "Monday May 14, 2018 5:30-7:30 pm", replace:replace, "1")

Thanks in advance

 

Functionality

Comments

We've figured it out.  All I had to do was add the = sign in to the formula

=COUNTIFS([Date of Class]:[Date of Class], ="Monday May 14, 2018 5:30-7:30 pm", replace:replace, ="1")

Thanks