As the Unit states, COUNT ignores cells containing blanks or strings, only counting cells with numbers. However, if you type the following into a cell:
=COUNTIF(A1:A4,"one")
and the cells have the following strings as comma-delimited data:
one, one, two, 2
Excel will return a value of “2”—in other words, it’s counted the two instances the word “one” appeared in the data! Thinking through how both conditionals and logical operators work, why is Excel able to actually “count” here? If all instances of the word “one” were changed to the string “TRUE” in the data and the formula, would you get the same answer? What would a simple COUNT command return?
