Thread: How do I evaluate a row of cells for a character in each cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
  
Posts: 1,397
Default How do I evaluate a row of cells for a character in each cell?
try
=countif(range,"X")
similar for "P" and "N"

"TwoDot" wrote:

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