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