Calculating frequency?
 

I am trying determine how many times a number occurs a five column data
sheet. They are between 1 and 100. I just can't get the formula to give me
an answer. Can someone help?

Lost in formuland-
Thanks-
Ken

Calculating frequency?
 

Numbers in A1:E100
In F1we have the number 10
In f2 =COUNTIF(A1:E100,F1) tell us how many times 10 appears in A1:B100

What formula did you try?
Bernard

"Ken" wrote in message
...
I am trying determine how many times a number occurs a five column data
sheet. They are between 1 and 100. I just can't get the formula to give
me an answer. Can someone help?

Lost in formuland-
Thanks-
Ken

Calculating frequency?
 

Hi!

One way:

Assume your 5 column table is in the range A1:E1000

Enter this formula in G1:

=ROWS($1:1)

Enter this formula in H1:

=COUNTIF(A$1:E$1000,G1)

Select both G1 and H1 and copy down to row 100.

Biff

"Ken" wrote in message
...
I am trying determine how many times a number occurs a five column data
sheet. They are between 1 and 100. I just can't get the formula to give
me an answer. Can someone help?

Lost in formuland-
Thanks-
Ken