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

[TwoDot]

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

 

[bj]

try
=countif(range,"X")
similar for "P" and "N"

 

[Ron Coderre]

Try something like this:

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

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

XL2002, WinXP