Calculating frequency?

[Ken]

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

 

[bernard liengme]

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

 

[Biff]

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