Countif?

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

Guest

working with 8 columns and 30+ rows by place an "x" in various places, I need
a formula that will tell me how many rows have 2 or more "x" in it.
 
Try this array formula**:

=SUMPRODUCT(--(MMULT(--(A1:H30="X"),TRANSPOSE(COLUMN(A1:H30)^0))>=2))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)
 

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

Finding the weighted average of text that have been given values 1
countif2 1
Scrabble Value calculation for Welsh words 0
Need Help FAST with COUNTIF Formula 0
Adding up total hours worked on employee schedule using various criteria 0
Using a macro to enter a formula 4
Excel Dragging countif formula with changing criteria 3
Excel Help to copy information from one row at a time to another sheet 1

Back
Top