Counting the numbers

Hi All,
Is there any formula that counts the occurence of numbers in a data range based on certain criteria?

Fox example.
Say i have a data from A1 till H1 and now i would like to count an occurence of the number till 5 columns (till E1) and would like to get the count.

What is the criteria?
Actually you can use
=count(A1:E1)

Actually i dont want any hard coded formula, the data range will be fromA1 till H1 and the required range will be specified in a cell.

=count(indirect(cell_with_range))

Keep in mind that INDIRECT is volatile

Hi arthurbr thanks for your help,
Somehow its not working, might be i dont know how to apply the formula.
I will rephrase my requirement.
There is a cell (Cell A1) wherein i have numbers and i have a data range.
Based on the number in cell A1 the formula should count the occurence of numbers in the data range that i have.

Say in cell A1 number is 5 and my data range is from C1 till K1 and the numbers in the data range is as follows i have numbers i C1 D1 F1 J1. In the data range in all i have 4 occurence of the numbers. Now i want the formula which will just count the numbers in the first 5 column of the data range. The formula should start counting from C1 till G1 and fetch me the occurence of the numbers from the data range.
Hope i have expressed my requirement with the clarity.

You can use INDEX

=COUNT(C1:INDEX(C1:K1,A1))

Thanks a lot my dear friend, its working now.
Just wondering why have you created your user ID name as Donkey, its not matching up with your skill

Originally Posted by mangesh

Just wondering why have you created your user ID name as Donkey, its not matching up with your skill

unfortunately everything is relative ...