Countifs is ignoring one of my criteria

New Contributor


I'm trying to count Mon - Sat by using Countifs formula but it ignored "Wed" and only counted as 2 not 3.

2 Replies
best response confirmed by Hankun (New Contributor)


Could there be a space after Wed in row 5?

It works! Din't know it was that sensitive for a string value... thanks