Hi to all
I would like to count number of * stars between words in a range in a column. I used this formula
=COUNTIF(rng,"*"&b1&"*"),but no success, I think excel considering * as wildcard and counting all the cells. This formula giving 9 stars (*) but actually I have 4 in my range. Any help would be highly appreciated and thanks in advance
<colgroup><col width="64" style="width: 48pt;" span="3">
<tbody>
</tbody>
Thanks in advance
Genetist
I would like to count number of * stars between words in a range in a column. I used this formula
=COUNTIF(rng,"*"&b1&"*"),but no success, I think excel considering * as wildcard and counting all the cells. This formula giving 9 stars (*) but actually I have 4 in my range. Any help would be highly appreciated and thanks in advance
A*C | Word | Count |
A*A | * | 9 |
G*G | ||
C*C | ||
T*T | ||
AA | ||
TT | ||
CC | ||
GG |
Thanks in advance
Genetist