To count the number of X's, use:

=LEN(A1&A2&A3)-LEN(SUBSTITUTE(A1&A2&A3,"X",""))

this will show 5 for your posted data.
--
Gary''s Student - gsnu200802


"A.Mourice" wrote:

Hello,

A1 A,B,X,C,X
A2 X,D,G,X
A3 F,G,K,L,X


I need to count how many X repeated at many cells using sumproduct function.