Count cells containing less than greater than numbers

[jackt05]

Hi All,

I have to count the cells in a column, which have numbers less than 100 and more than 91

what formula should I use.


Thanks

 

[njimack]

=sumproduct(--(a1:a10>91),--(a1:a10<100))

 

[jackt05]

Perfect Thanks a lot

 

[Misca]

Try something like:

Excel Workbook
	A	B	C	D
1	List of numbers
2	100			100
3	101		>	90
4	102			4
5	99			5
6	98
7	90
8	100
9	95
10	82
Sheet