From: ExcelWizardImNot on 26 Mar 2010 22:38 That did it. Thanks much. "Huber57" wrote: > 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? From: מיכאל (מיקי) אבידן on 27 Mar 2010 05:09 In order to avoid the correction of each and every formula - in your private case - I would suggest, in cell C1 to type the following formula and copy down till C6: =COUNTIF(\$A\$1:\$A\$700,Row()-1) Micky "ExcelWizardImNot" wrote: > That did it. Thanks much. > > > "Huber57" wrote: > > > 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: How to reduce size of ms excel file-2003Next: tab in a cell