Thread: How do I evaluate a row of cells for a character in each cell?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TwoDot TwoDot is offline
external usenet poster
  
Posts: 5
Default How do I evaluate a row of cells for a character in each cell?
In a row of 52 cells, each cell contains an X or a P or an N. I want to
calculate the number of cells that contain an X and divide by 52 (or COUNTA
of the cell range).
Reply With QuoteReply With Quote