Count

[kumawat_s]

I am attaching a file.

I want to count the No. of values belongs to range 1-5 and 6-15.

Please suggest suitable function.

I am using excel 2002 version.

Thanks/ Shubhkaran

[lmvk99]

=count(b:b)

[TMS]

=SUMPRODUCT(--($B$1:$B$14>=1),--($B$1:$B$14<=5)) for the first range of numbers

Regards, TMS

[martindwilson]

you don't say if you have numbers less than 1 or greater than 15

[pike]

or with out sumproduct

=COUNT(INDEX((B1:B14)/((B1:B14>=1)*(B1:B14<=5)),))