How do I count in a range?

Hi!

I know the "countif" formula, but that just apolies for counting single numbers or other entries. But now want to count the occurance of number within a range.So I have a data, including years. What I want is counting how often occurance "X" occurs in a decade (1970-1979). So it should count 1970, 1971, 1972, etc until 1979.

How do I do that?

Thanks in advance!

ADB

you can try this:

=COUNTIF(E1:E28,">=1976")-COUNTIF(E1:E28,">1979")

or define year in A1:

=COUNTIF(E1:E28,">="&A1)-COUNTIF(E1:E28,">"&A1+9)

or by SUMPRODUCT function:

=SUMPRODUCT(--(E1:E28>=1976),--(E1:E28<=1979))