View Single Post
  #2   Report Post  
Domenic
 
Posts: n/a
Default

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.