From: ExcelWizardImNot on 26 Mar 2010 21:19 I use excell 2000. I have one column with 700 rows. In each cell is one number, either a 0, 1, 2, 3, 4, or 5. In the second column I have five rows, each with one number in increasing order: 0, 1, 2, 3, 4, 5. Next to the numbers 0-5 (in column three) I want the total number of occurances for each number in column one. So out of the 700 rows, if the number 2 occurred 230 times, I want the number 230 to show in column 3 to correspond to the number 2 in column two. Any ideas? From: Huber57 on 26 Mar 2010 21:55 Try this: In C1 (to count the zeros) =COUNTIF(\$A\$1:\$A\$701,"0") In C2 (to count the 1s): =COUNTIF(\$A\$1:\$A\$701,"1") etc. Hope that helps. If it does, rate it has helpful at the bottom of the post. "ExcelWizardImNot" wrote: > I use excell 2000. I have one column with 700 rows. In each cell is one > number, either a 0, 1, 2, 3, 4, or 5. In the second column I have five rows, > each with one number in increasing order: 0, 1, 2, 3, 4, 5. Next to the > numbers 0-5 (in column three) I want the total number of occurances for each > number in column one. So out of the 700 rows, if the number 2 occurred 230 > times, I want the number 230 to show in column 3 to correspond to the number > 2 in column two. Any ideas?  |  Pages: 1 Prev: make camera object refer to dynamic rangeNext: Doubt about pivot table