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?