Counting criteria in two columns
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
Help Article Resources
Check out the Formula Handbook template!