H H4Fi Nov 9, 2004 #1 I need a formula that will look at a row of letters and find ot how man "W"s there are. Thank
B BenjieLop Nov 9, 2004 #2 H4Fi said: I need a formula that will look at a row of letters and find ot how man "W"s there are. Thanks Click to expand... =countif(A1:A100,"W") where A1:A100 is the range where you have your letters
H4Fi said: I need a formula that will look at a row of letters and find ot how man "W"s there are. Thanks Click to expand... =countif(A1:A100,"W") where A1:A100 is the range where you have your letters
J JE McGimpsey Nov 9, 2004 #3 For a row, use =COUNTIF(1:1, "W") If the "W" could occur within other text in the cell, use =COUNTIF(1:1,"*W*")
For a row, use =COUNTIF(1:1, "W") If the "W" could occur within other text in the cell, use =COUNTIF(1:1,"*W*")
