Frequency

[Ellie]

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?

 

[T. Valko]

Try this:

=COUNTIF(A1:Z1,1)

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

 

[Gord Dibben]

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