YTD Formulas

Copper Contributor

I am having difficult with creating a YTD total for Columns d4:d15 and G4:g15.   D will be for the totals in C and G is for the totals in E.  I have attach my file below.

1 Reply

Hi Karen

 

Is it something like this you are after (see attached file)?

 

I have made a formula =SUM(last months total, this months total) which will add each completed month and your YTD as you go along for current month.

 

Hopefully I was understanding you right.

 

Good luck!

 

Cheers

Damien