Countif function for years

[Donna]

I'm trying to count the occurences of years within a certain range

I have a column with years appearing as follows
191
193
194
194
194
195
195
195
195

I want to group them into decades. Therefore I need to count the occurences between 1910 and 1919, 1920 and 1929, etc etc. How do I do this?

Thanks for your help.

 

[Bob Phillips]

Donna,

Assuming the years are all that is stored, not a date, then try

=SUMPRODUCT((A1:A100>=1910)*(A1:A100<1919))

etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I'm trying to count the occurences of years within a certain range.

I have a column with years appearing as follows:
1911
1932
1941
1942
1945
1951
1952
1954
1955

I want to group them into decades. Therefore I need to count the

occurences between 1910 and 1919, 1920 and 1929, etc etc. How do I do
this??

 

[Donna]

Never mind... I found help from another thread.

Thanks to Peo Sjoblom for the help!

 

[Frank Kabel]

Hi
in addition to Bob: If the years are stored as dates use
=SUMPRODUCT((A1:A100>=DATE(1910,1,1))*(A1:A100<DATE(1919,1,1)))

Frank