SOLVED

Countifs is ignoring one of my criteria

New Contributor

Hankun_0-1658320864849.png

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)
Solution

@Hankun 

Could there be a space after Wed in row 5?

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