Sub total data by year

T

Trond

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?
 
D

David Billigmeier

Just need to specify a year_num in the following formula:

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