Count frequence in one column

  • Thread starter Excel Sum function with IF
  • Start date
E

Excel Sum function with IF

I am trying to set a formula that will count how many frequency in the column
that match the criteria...

I have one column that has p, c, and v which means p as participants, c as
committee, and v as volunteers. I would like to count how many p there are
in the column into different sheet and same thing for c and v. any
suggestion?
 
E

Elkar

You could use COUNTIF:

=COUNTIF(A1:A100,"p")

This will count the number of times "p" occurs in the range A1 through A100.
Repeat the formula substituting your other letters.

HTH
Elkar
 

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

Select Text to End of Footnote 9
Counting with multiple criteria in multiple columns 1
How to count the numbers in a Word document? 0
List items based on the count given 4
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Sum a column is criteria in two in column and other column are met 2
Loop is slow trying array code 17
Count Data in Series 2

Top