Counting criteria in two columns

Stephanie Taylor

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

 

L_123

1 shouldn't be in quotes.

Stephanie Taylor

I've tried that and it still doesn't work.  I keep getting 0

L_123

https://app.smartsheet.com/b/publish?EQBCT=deda62cf14ba4608a673d1f5e67c009c

 

I'm not entirely sure then. It works for me. What are your column types?

Stephanie Taylor

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