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.