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

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

Thank you

=countif(D1:G4,"x")

Adjust range to suit.............

Vaya con Dios,
Chuck, CABGx3



"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

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

This is perfect, thank you very much!

"JE McGimpsey" wrote:

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