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?

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 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?