what i wanna do is say i have area from a1 to d10 with numbers i would like to be able to get a formula into the cell which counts how many times 3 or more numbers appear into defined area...example say in cell h5 i wanna see results as a count how many times 3,4,5 appeared in area a1 to d10 so if number 3 appeared 1 time,4 appeared 1time and 5 appeared 1time then result in cell has to be 3 times...thanks
should be able to use the COUNTIF function...
=COUNTIF(a1:d10,OR(3,4,5))
something like that
thsi will do what you want :-)
thank you very much...stepkevh your one works but is not what i wanted and matty i did try yours but return o value...say i have 1 cell and four numbers arround the cell and i have area a1:p40 with numbers ,i am trying to count sum of how many times them 4 numbers hit whitin area..
so you want to search for 4 given numbers in the area A1 : P40 ?
yes
i worked it out ....thanks very much
no problem