Thread: sumproduct text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
A.Mourice[_2_] A.Mourice[_2_] is offline
external usenet poster
  
Posts: 3
Default sumproduct text
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 QuoteReply With Quote