Countif function for years

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)

Donna said:
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
Click to expand...
occurences between 1910 and 1919, 1920 and 1929, etc etc. How do I do
this??
 
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
 
Back
Top