One way:

=COUNTIF(N8,"X")+COUNTIF(S8,"X")+COUNTIF(X8,"X")

Or, if your pattern continues:

=SUMPRODUCT(--(N8:X8="X"),--(MOD(COLUMN(N8:X8),5)=4))

In article ,
"GVDLS" wrote:

I would like to count how many X's are in various cells within a worksheet.

Example: =countif(N8,S8,X8=X)

Thank you