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

Sum a column is criteria in two in column and other column are met 2
Count Data in Series 2
COUNT and SUM 5
CountIf question 2
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
count unique values in one column for a set value in another col. 2
Count the columns from one sheet and paste it in another sheet 0
Help adding letters in column 2

Top