Sub total data by year

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

[David Billigmeier]

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?

[Trond]

Amazing! How simple when you know what to do. Thank you very much.

Regards,

Trond

"David Billigmeier" wrote:

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