SOLVED

Countifs is ignoring one of my criteria

Copper 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 (Copper 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
1 best response

Accepted Solutions
best response confirmed by Hankun (Copper Contributor)
Solution

@Hankun 

Could there be a space after Wed in row 5?

View solution in original post