I am trying to use countif to count cells that have text in a range. Can someone help? Thanks. Joe
J Joseph M. Yonek Sep 25, 2003 #1 I am trying to use countif to count cells that have text in a range. Can someone help? Thanks. Joe
M mikelee Sep 25, 2003 #2 not sure about countif, but you can use count and counta to do it. =counta(range) - count(range) counta will count the nonblank cells, and count will count the cells with numbers in them. the remainder should be the cells with text. hope that helps.
not sure about countif, but you can use count and counta to do it. =counta(range) - count(range) counta will count the nonblank cells, and count will count the cells with numbers in them. the remainder should be the cells with text. hope that helps.
