sumproduct text
I use the same equation at the following, but it didn't work
A1 1-, 2-, 3-,
A2 2-, 1-, 10-
A3 3-, 1-, 2-, 1-
I need to count how many 1- using sumproduct function
Thanks
"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.
|