count numbers in specific range

**mubashar** · 01-20-2014, 01:57 AM

hi, i need coding in command button click event ... that .. to count how many numbers are present between 150 to 200 in column M .

**HaHoBe** · 01-20-2014, 02:04 AM

Hi, mubashar,

maybe like this avoiding a loop:

Please Login or Register  to view this content.

Ciao,
Holger

**millz** · 01-20-2014, 02:05 AM

Did you try the Count function?
By "count how many numbers", you mean how many cells containing numbers? or if a cell contains "4235" it is considered 4 numbers?

Please Login or Register  to view this content.

**mubashar** · 01-20-2014, 02:33 AM

in column M it contains random numbers , i need how many cells in column M have values in between 150 to 200, and how many cells have value inbetween 200 to 250 and so on