One way
In B1:
=SUMPRODUCT(--(LEN(A1:A3)-LEN(SUBSTITUTE(A1:A3,"X",""))))
Adapt the range to suit
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik
---
"A.Mourice" wrote:
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.