tycasey17
Board Regular
- Joined
- Sep 26, 2013
- Messages
- 93
- Office Version
- 2019
- 2016
- Platform
- Windows
I am trying to count the number of M's listed in four sections of a sheet but it will only return the value of 0 no matter what I put in the cells. Does anyone know why it does this because it doesn't make sense.
Example:
=COUNTIFS(A1:C1,"M",A2:C2,"M")
Example:
=COUNTIFS(A1:C1,"M",A2:C2,"M")