Just need to specify a year_num in the following formula:

=SUMPRODUCT(--(YEAR(B1:B3000)=year_num),C1:C3000)

--
Regards,
Dave


"Trond" wrote:

I have a sheet with about 3000 rows for claim data. Column B shows Date,
Column C shows amount. The date range spans many years. I want to sub-total
amount per callendar year. I tried SUMIF but could not make it work. Any
ideas?