For the number of x's...
=COUNTIF(A1:G1,"x")
For the number of x's and t's...
=SUMPRODUCT(--(ISNUMBER(MATCH(A1:G1,{"x","t"},0))))
Hope this helps!
In article ,
ddwchs wrote:
What is the formula for finding the total number of letters in a range of
cells? Example - How many x's and how many t,s in cels A1:G1.
|