Count???

[TimE]

I have a range of numbers that I would like to count by criteria. Criteria would be a range...say (>=20 and <=40). Is this possible to do with countif?

52
18
21
24
33
36
47

[frankybenali]

For more than one criteria you need to use SUMPRODUCT or an array formula:

SUMPRODUCT formula would be:

=SUMPRODUCT((A1:A6>=20)*(A1:A6<=40))

[TimE]

Thank you for your assistance.