countif

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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))
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF clause for a range of cells 3
Finding the weighted average of text that have been given values 1
Excel Need Countifs Formula Help 0
Need a ) somewhere in ISERROR formula but don't know where to put it 3
numbers, text 1
COUNTIF with 2 columns 2
Excel function - countif 2
countifs Function not giving desired result with date criteria 2

Back
Top