How to Count Text Occurrences in a Column??

  • Thread starter Thread starter JW
  • Start date Start date
J

JW

I'm using Excel 2002. I have a large spreadsheet containing columns of
letters, a through e, representing answers to a multiple choice quiz. I want
to count the number of "a's", "b's", "c's", etc in each column. I thought I
could do that using the "count" function, but I'm not getting there. I would
appreciate any suggestions on how to accomplish that. Thanks for your help.
 
=countif(a1:a10,"A")
I'm using Excel 2002. I have a large spreadsheet containing columns of
letters, a through e, representing answers to a multiple choice quiz. I want
to count the number of "a's", "b's", "c's", etc in each column. I thought I
could do that using the "count" function, but I'm not getting there. I would
appreciate any suggestions on how to accomplish that. Thanks for your help.
Click to expand...
 
What if there were multiple text choices you wanted to count - would you
need separate Countif's for each?
Click to expand...

=COUNTIF(A1:A10,"A")+COUNTIF(A1:A10,"B")
or
=SUMPRODUCT((A1:A10="A")+(A1:A10="B"))
will count As and Bs

Ken Johnson
 
If you wanted a separate count of each, then yes.

But if you wanted to count all the A's, B's and C's, you could also use:
=sum(countif(a1:a10,{"A","B","C"}))
 
If you wanted a separate count of each, then yes.
Click to expand...

That's what I was afraid of - thanks anyway.
But if you wanted to count all the A's, B's and C's, you could also use:
=sum(countif(a1:a10,{"A","B","C"}))
Click to expand...

This might be of some use, though.
 
Back
Top