Frequency
 

How do you calculate the number of times a certain number comes up in a row?

For example, the number of 1s, 2s, 3s, 4s, 5s, 6s, 7s, 8s, 9s, in each row?

Frequency
 

Try this:

=COUNTIF(A1:Z1,1)

That will count the number of 1s in the referenced range.

--
Biff
Microsoft Excel MVP


"Ellie" wrote in message
...
How do you calculate the number of times a certain number comes up in a
row?

For example, the number of 1s, 2s, 3s, 4s, 5s, 6s, 7s, 8s, 9s, in each
row?

Frequency
 

FREQUENCY function will do this.

See help on that function.

Basically you need a source range which would be your row.

Then you need a Bins array which would be the numbers 1 through 9

Don't forget to CTRL + SHIFT + ENTER as this is an array function.


Gord Dibben MS Excel MVP

On Sun, 1 Mar 2009 22:53:01 -0800, Ellie
wrote:

How do you calculate the number of times a certain number comes up in a row?

For example, the number of 1s, 2s, 3s, 4s, 5s, 6s, 7s, 8s, 9s, in each row?