Made a formula automatic

[Gian1959]

Good morrow everyone,

First of all please excuse my lack of knowledge of the English language .
I am a new forum user and I hope that someone can help me.

I have a database with over 10,000 lines full of numbers in three adjacent columns.
I'm using this formula to find the number of cells in wich the number is present, the frequencies in practice .

=CONTA.SE(C2:E9131; "1")
=CONTA.SE(C2:E9131; "2")
=CONTA.SE(C2:E9131; "3")
=CONTA.SE(C2:E9131; "4")
=CONTA.SE(C2:E9131; "n")
=CONTA.SE(C2:E9131; "etc")
=CONTA.SE(C2:E9131; "99")
=CONTA.SE(C2:E9131; "100")
=CONTA.SE(C2:E9131; "101")
=CONTA.SE(C2:E9131; "102")
=CONTA.SE(C2:E9131; "etc")


So far I've changed hand every formula by increasing the number between " " , but it is a long process.
I wonder if it can be done automatically, that is, if it is possible modify the formula (or other way) so that the numbers between " " are automatically increased by one unit .
Grateful if someone could help me .
Gian1959

[Jonmo1]

Try

=CONTA.SE(C$2:E$9131; ROWS($1:1))

I'm not sure what the Italian version of ROWS is, you'll have to find it.

[Gian1959]

Try

=CONTA.SE(C$2:E$9131; ROWS($1:1))

I'm not sure what the Italian version of ROWS is, you'll have to find it.

The formula works perfectly ' =CONTA.SE(C$2:$9131;RIGHE($1:1)) '
Thank you very much in this way is much easier to work .
Gian1959

[Jonmo1]

You're welcome

[Gian1959]

Good morning everyone
recently at my request I have solved my problem with an immediate response of
Jonmo1 who advised me to try this formula :

= CONTA.SE ( C $ 2: $ 9,131 ; ROWS ( $ 1: 1 ) )

it works perfectly. Today I would like to ask if it is possible add to
this formula something that allows me to print the rows that come out from the formula.
Many thanks
Gian1959