Counting criteria in two columns

Stephanie Taylor
Stephanie Taylor ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

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

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!