Sub total data by year

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Trond - 16 Aug 2006 20:55 GMT

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?

Reply to this Message

David Billigmeier - 16 Aug 2006 21:03 GMT

Just need to specify a year_num in the following formula:

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

Signature

Regards,
Dave

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

Reply to this Message

Trond - 16 Aug 2006 22:21 GMT

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

Regards,

Trond

> Just need to specify a year_num in the following formula:
>
[quoted text clipped - 4 lines]
> > amount per callendar year. I tried SUMIF but could not make it work. Any
> > ideas?

Reply to this Message