Thread: Counting the appearance of a String in a Row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default Counting the appearance of a String in a Row


How can I find out how many times GBOX appeared in ROW 2?
=COUNTIF(B2:B5,"GBOX")

And how many Articels I have with Pnumber GBOX?
=SUMPRODUCT((A2:A5<"")/COUNTIF(A2:A5,A2:A5),--(B2:B5="GBOX"))

Regards,
Stefi

Reply With QuoteReply With Quote