count number of years 2003 in a range of dates
Hi All!
I have a column of dates in column A:A and want to count the number of dates that have the year 2003 in them. I am trying to use =countif(year(A:A),2003) but it does not want to take that formula, it says there is a mistake in it. Can anyone help? Thanks so much!! Stan |
Stan,
The following will work, just not on a whole column =SUMPRODUCT((YEAR(A1:A1000)=2003)*1) HTH, Bernie MS Excel MVP "Stan Altshuller" wrote in message ... Hi All! I have a column of dates in column A:A and want to count the number of dates that have the year 2003 in them. I am trying to use =countif(year(A:A),2003) but it does not want to take that formula, it says there is a mistake in it. Can anyone help? Thanks so much!! Stan |
Stan, here is one way,
=SUMPRODUCT((YEAR(A1:A100)=2003)+0) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Stan Altshuller" wrote in message ... Hi All! I have a column of dates in column A:A and want to count the number of dates that have the year 2003 in them. I am trying to use =countif(year(A:A),2003) but it does not want to take that formula, it says there is a mistake in it. Can anyone help? Thanks so much!! Stan |
All times are GMT +1. The time now is 04:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com