Forum Discussion

Copper Contributor

Jul 20, 2022

Solved

Countifs is ignoring one of my criteria

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

Formulas and Functions

HansVogelaar
Jul 20, 2022
Hankun

Could there be a space after Wed in row 5?

2 Replies

HansVogelaar
MVP
Jul 20, 2022
Hankun

Could there be a space after Wed in row 5?
- Hankun
  Copper Contributor
  Jul 20, 2022
  It works! Din't know it was that sensitive for a string value... thanks

Resources