Sum revenues by year

That doesnt seem to be working. Im thinking I need some sort of SumIf statement, but I cant seem to get it right. Any other ideas?

This can be done one of two ways (See attached file to follow along):

Book1.zip

1) Use a SUMIF function:
=SUMIF($A$2:$A$25,$A29,$B$2:$B$25)

2) Use a CSE (Control+Shift+Enter) funtion (also called an array function):
=SUM(IF($A$2:$A$25=$A29,$B$2:$B$25))

*NOTE: you must press Ctrl+Shift+Enter for this to work, otherwise you'll get a #VALUE! Error

Good luck!

Sorry, I should have described my spreadsheet a little better. Those methods would work except that my dates are in mm/dd/yyyy format. I can always do a =Year() function in a seperate column, but it would look a little cluttered. Will the sumif() or the sum(if()) work with a full date?