Thread: Help! With SUMPRODUCT
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carim
 
Posts: n/a
Default Help! With SUMPRODUCT
Hi,

Is Sumproduct() really needed ...
Here is the formula I am using :

=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))

HTH
Cheers
Carim

Reply With QuoteReply With Quote