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