Re: 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" <PharmaThinkTankNS@xxxxxxxxxxx> wrote in message
news:1rGdnUc-m6Nr7uLenZ2dnUVZ_t2dnZ2d@xxxxxxxxxxxxxx
>I am trying determine how many times a number occurs a five column data
>***. 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
>


.


Loading