Thread
:
sumproduct text
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
Posts: 3,718
sumproduct text
=SUMPRODUCT(LEN(A1:A3)-LEN(SUBSTITUTE(UPPER(A1:A3),"X","")))
"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.
Reply With Quote
Teethless mama
View Public Profile
Find all posts by Teethless mama