software

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,quot;xquot;)

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

Vaya con Dios,
Chuck, CABGx3
quot;GVDLSquot; wrote:

gt; I would like to count how many X's are in various cells within a worksheet.
gt;
gt; Example: =countif(N8,S8,X8=X)
gt;
gt; Thank you

One way:

=COUNTIF(N8,quot;Xquot;) COUNTIF(S8,quot;Xquot;) COUNTIF(X8,quot;Xquot;)

Or, if your pattern continues:

=SUMPRODUCT(--(N8:X8=quot;Xquot;),--(MOD(COLUMN(N8:X8),5)=4))

In article gt;,
quot;GVDLSquot; gt; wrote:

gt; I would like to count how many X's are in various cells within a worksheet.
gt;
gt; Example: =countif(N8,S8,X8=X)
gt;
gt; Thank you

This is perfect, thank you very much!

quot;JE McGimpseyquot; wrote:

gt; One way:
gt;
gt; =COUNTIF(N8,quot;Xquot;) COUNTIF(S8,quot;Xquot;) COUNTIF(X8,quot;Xquot;)
gt;
gt; Or, if your pattern continues:
gt;
gt; =SUMPRODUCT(--(N8:X8=quot;Xquot;),--(MOD(COLUMN(N8:X8),5)=4))
gt;
gt; In article gt;,
gt; quot;GVDLSquot; gt; wrote:
gt;
gt; gt; I would like to count how many X's are in various cells within a worksheet.
gt; gt;
gt; gt; Example: =countif(N8,S8,X8=X)
gt; gt;
gt; gt; Thank you
gt;