| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count frequence in one column
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count frequence in one column
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 "Excel Sum function with IF" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count cells w/values in column if the data in column a matches cri | Excel Worksheet Functions | |||
| Count number of cells and total in one column, based on another column suffix | Excel Worksheet Functions | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE. | Excel Worksheet Functions | |||
![Excel Sum function with IF[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
