countif

G

GVDLS

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

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

Thank you
 
J

JE McGimpsey

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

GVDLS

This is perfect, thank you very much!

JE McGimpsey said:
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))
Click to expand...
 
Top