countif. dates in a year (year is the criteria)

I have a table with a column of dates. I's like to use countif or sumif. The criteria I would like to use is simply a year (2010), so any date that falls within that year (2010) would be included in the calculation.

I'd like to do this without creating a new column for year. In the future, I might want to do a countif and include all dates that are in one month of a year. can the cell function be made to do this?

Try

=Sumproduct(--(YEAR(A1:A1000)=2010)) for counting

and


=Sumproduct(--(YEAR(A1:A1000)=2010),B1:B1000) for summing

adjust ranges to suit

For the year,

=SUMPRODUCT((1*(YEAR(A1:A100)=2010)))

for a month as well (eg january)

=SUMPRODUCT((1*(YEAR(A1:A100)=2010))*(MONTH(A1:A100)=1))

thanks. works!