how do i create year-to-date formulas?

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

Post Flair (click to view more posts with a particular flair)

unsolved

Post Body

I'm trying to figure out how I can write a YTD formula.

Let's say that it's the month of May and I have a YTD formula in, say, Col X. X1 says the month name, May.

I'd like to add up the data for all the months so far. I can either add Q1 Apr May or add up the individual months.

So far I've been manually doing this every month. But is there a formula I can write that would automatically update? Ideally when I change the month name, all the YTD numbers should change. I cant figure out how to do that though.

							May
Jan	Feb	Mar	Q1	Apr	May		YTD
1	2	3	6	1	2		8

Author

Account Strength

50%

Account Age

1 year

Verified Email

Yes

Verified Flair

Total Karma

785

Link Karma

Comment Karma

755

Profile updated: 1 day ago

Posts updated: 3 weeks ago

QuantumAccelerator1

Subreddit

r/excel

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 9 months ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/excel/comme...