sumproduct text
changing the formula:
=LEN(A1&A2&A3)-LEN(SUBSTITUTE(A1&A2&A3,"1-",""))
you should see 8
--
Gary''s Student - gsnu200802
"Gary''s Student" wrote:
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.
|