What is the formula for cumulative year to date totals in Excel?

S

SouthernMade

What is the formula for cumulative year to date totals in Excel? I am setting
up a worksheet where a monthly total is entered and then added to another
column for a year to date total. Thank you
 
F

Fred Smith

The standard is to store all months in the spreadsheet. The problem with
adding the entered month to a cumulative total is, what if you make a
mistake? How do you correct it?

When you store all months, errors are easy to correct, and you have a much
better history of your data.

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for selecting a Leap Year. 7
Cumulative totals carrying over to several spreadsheets 4
Time Sheet Summary 1
Weekly Time Sheet Summary 2
Weekly Time Sheet Consolidate 1
Calculate Amount Based on Year 3
Excel Vba to change displayed year automatically. 14
formula to add year to date figures 3

Top