Hi =COUNTIF(A:A,"*best*)
C Clint Wagner Jul 26, 2004 #2 Quick One for the guru's: I am trying to write an IF/Count statement that goes like this: Count the number of cells in Column A that contain the word "best". Any clues as to the best way to go about this? Clint
Quick One for the guru's: I am trying to write an IF/Count statement that goes like this: Count the number of cells in Column A that contain the word "best". Any clues as to the best way to go about this? Clint
M merjet Jul 26, 2004 #3 I am trying to write an IF/Count statement that goes like this: Count the number of cells in Column A that contain the word "best". Any clues as to the best way to go about this? Click to expand... As a worksheet function: =COUNTIF(A:A,"=best") HTH, Merjet
I am trying to write an IF/Count statement that goes like this: Count the number of cells in Column A that contain the word "best". Any clues as to the best way to go about this? Click to expand... As a worksheet function: =COUNTIF(A:A,"=best") HTH, Merjet
