can somebody give a formula in ms excel that counts the cells whose data is equal to the number you are asking

Question

for example, in a given column the values are 10, 7, 6, 5,10 and 6. and i am looking for how many 10's are there. the result would give me 2.

Answer 1

That will be
countif()

There is also
sumif()