:849240"},"body":"Is there a way of counting a specific word in a column but not count the word if it's in a coloured cell?","body@stringLength":"105","rawBody":"Is there a way of counting a specific word in a column but not count the word if it's in a coloured cell?
Identifying zeros is a little more complicated. To locate cells with zeros in them we can use =IF(B2=0, “ZERO”, “”), but Excel will return a zero when the reference cell is blank. Oops. How silly of Microsoft. Did no one ever tell them that zero is a real number and an emp...