just question about excel

[maestro]

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

[mattymattz]

should be able to use the COUNTIF function...

=COUNTIF(a1:d10,OR(3,4,5))

something like that

[Stepkevh]

thsi will do what you want :-)

[maestro]

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..

[Stepkevh]

so you want to search for 4 given numbers in the area A1 : P40 ?

[maestro]

yes

[maestro]

i worked it out ....thanks very much

[Stepkevh]

no problem