ExcelBanter - Need help with an excel formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Need help with an excel formula (https://www.excelbanter.com/excel-programming/370957-need-help-excel-formula.html)

duse

Need help with an excel formula

In 40 lines many times over, I need to enter numbers from 1 to 6. whats
the formula to see how many times a specific number has been entered?
--
Fabio

moon[_5_]

Need help with an excel formula

=COUNTIF( range, criteria )

"duse" schreef in bericht
...
In 40 lines many times over, I need to enter numbers from 1 to 6. what's
the formula to see how many times a specific number has been entered?
--
Fabio

All times are GMT +1. The time now is 01:10 AM.