Hi Expert,

Wondering simple function is possible using match and count in a given range (a1:g7) :-
Given row range (a1:g7)each cell numbers are
2,20,38,29,6,8, 10

need to count specific numbers only 2,20,29 answer is 3

Thanks
Karnik