Ongoing YTD totals

[Humble Newbie]

Good afternoon!

Column A contains dates going back 5 years, from row 10 downwards, and column C contains numerical values for those dates. Dates are being added almost every day.

What I want to do is sum the values for the current year to date, whatever that happens to be i.e. when 2006 comes around Excel will know it's a new year and start subtotalling again.

Is this possible?

 

[NBVC]

Can you use something like:

=If(Year(cell_ref)=Year(today()),do if true, do if false)

 

[Humble Newbie]

Hello NBVC, thank you for replying.

I don't really understand your formula I'm afraid!

If I want the subtotal for the current year, say in A1, do I just enter: =If(Year(A1)=Year(today()),do if true, do if false) ?

Sorry but I'm pretty inexperienced with all this.

 

[NBVC]

Hi,

I think for what you have told me in your initial post, something like this is what you need:

=SUM(IF(YEAR(A1:A100)=YEAR(TODAY()),C1:C100)),

Where A1:A100 contains the dates and C1:C100 contains the numbers. Adjust as necessary.

Note: To confirm the formula use CTRL+SHIFT+ENTER instead of just ENTER.

Hope this helps.

 

[Humble Newbie]

That worked great - thank you very much!