counting number of cells with same number

Hy, Ireally need your help,
I need to know wich formula or VB method, I have to use to count the number of cases in a range of colomns and rows C4:G107, have the same number. For eaxample how many times do I have number 1 and so on...

Thank you for your time
Charles

Originally Posted by charlie44

Hy, Ireally need your help,
I need to know wich formula or VB method, I have to use to count the number of cases in a range of colomns and rows C4:G107, have the same number. For eaxample how many times do I have number 1 and so on...

Thank you for your time
Charles

Something like this:

=COUNTIF(G4:G107,"1")

thanks Portuga, but it's says invalid? do you any clue?

Originally Posted by charlie44

thanks Portuga, but it's says invalid? do you any clue?

No idea(??)
I tested it and It works in my machine.
What is the version of excel you are using?

the version is exccel '97, actually it works better with this formula:
COUNTIF(C4:G107,1)
but I do not understand when I am asked for criteria, what should I include?

countif can do funny things if your cells include 'text'. Make sure the cells are all 'values' and then try the countif function.

Great it works, thank you very much all of you, actually I am trying to make statistics for lottery, I will recontact for any help