keeping track of how many times a number shows up

**rismr** · 04-22-2009, 03:59 PM

Say, for example, I have a spreadsheet as follows:

0 1 1 2 3 2 0 1 2
1 2 1 2 3 3 1 0 1

Is there a way to count the number of times a specific number shows up and have excel post it to a different cell? I need to know how many times a certain number came up for a specific row, and how many times. Thanks

**NBVC** · 04-22-2009, 04:02 PM

Use Countif()

e.g. =Countif(A1:I1,1) will count number of 1's in A1 to I1

**rismr** · 04-22-2009, 04:06 PM

thanks for the fast reply.

it seems to work perfectly if i use a number as the criteria, but not if i use a "Y" or "N" does this function only work with numbers and not letters?

**NBVC** · 04-22-2009, 04:07 PM

if you use "Y" or "N" it must be in quotes as you show...

e.g. =Countif(A1:I1,"Y")

**rismr** · 04-22-2009, 04:09 PM

thanks for the help :D

**NBVC** · 04-22-2009, 04:14 PM

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save