How can I use the COUNTIF formula on a group of specific cells?

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

Guest

I have a worksheet with Yes/No questions. I'm trying to recognize and count
each "x" in the Yes field for each specific question and it's not allowing me
to.

I can get it to add a range of cells, but not a group of specific cells.

Anyone know how to do this?


Thought it would look a little like this: =COUNTIF((B6,H6,I6,B21,H21,I21)"X")

Thanks for the help!
 
but not a group of specific cells.

EXACTLY which specific cells?

Biff
 
=SUMPRODUCT(COUNTIF(INDIRECT({"B6","H6","I6","B21","H21","I21"}),"X"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
And one more:
=(B6="x")+(H6="x")+(I6="x")+(B21="x")+(H21="x")+(I21="x")
 
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

Selecting specific cells in a column using countif 1
Excel Use COUNTIF across a range of cells with formulas 0
COUNTIF on result of formula 4
Using COUNTIF on specific cells 4
Average using lookup function 9
COUNTIF Cells in Range? 4
Using a sub string in a COUNTIF 2
Sumif/countif 2

Back
Top