ExcelBanter - Count number of times a specific number is displayed in cells

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

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

- - Count number of times a specific number is displayed in cells (https://www.excelbanter.com/excel-programming/332923-count-number-times-specific-number-displayed-cells.html)

subs[_2_]

Count number of times a specific number is displayed in cells

How can you count the number of times a specific number is displayed in a
group of cells?

Tom Ogilvy

Count number of times a specific number is displayed in cells

=countif(A1:Z26,123)

if some of the cells contain the number 123

or in VBA

msgbox Application.Countif(Range("A1:Z26"),123)

--
Regards,
Tom Ogilvy

"subs" wrote in message
...
How can you count the number of times a specific number is displayed in a
group of cells?

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