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).

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).

How do I evaluate a row of cells for a character in each cell?
 

Try something like this:

=COUNTIF(A1:A52,"X")/COUNTA(A1:A52)

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"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).