Sum Year to Date

[ManUBlueJay]

I am looking for a formula that would be dynamic as my table grows it will automatically grow. Starting from January 2014 I would like to compare Jan 2014 to Jan 2013. Feb 2014 needs to sum (Jan, Feb 2014) to Jan, Feb 2013).... At year change it starts again . All I need help is for Team A YTD. I can figure the rest out.

Year	Month	Team A	Team B	TOT	Team A YTD	Team B YTD	TOT YTD
2013​	January	£887,123​	£826,010​	£1,713,133​
2013​	February	£1,083,593​	£994,373​	£2,077,966​
2013​	March	£1,113,945​	£998,722​	£2,112,667​
2013​	April	£539,035​	£451,662​	£990,697​
2013​	May	£784,840​	£544,922​	£1,329,762​
2013​	June	£1,053,068​	£686,390​	£1,739,458​
2013​	July	£1,519,950​	£1,032,760​	£2,552,710​
2013​	August	£894,571​	£645,266​	£1,539,837​
2013​	September	£846,800​	£639,790​	£1,486,590​
2013​	October	£910,129​	£661,449​	£1,571,578​
2013​	November	£810,981​	£612,243​	£1,423,224​
2013​	December	£733,753​	£579,605​	£1,313,358​
2014​	January	£962,528​	£682,318​	£1,644,846​
2014​	February	£1,538,946​	£1,218,207​	£2,757,153​
2014​	March	£1,578,859​	£1,447,862​	£3,026,721​
2014​	April	£1,006,719​	£1,011,942​	£2,018,661​
2014​	May	£781,498​	£778,578​	£1,560,076​
2014​	June	£1,028,055​	£941,731​	£1,969,786​
2014​	July	£1,703,107​	£1,715,999​	£3,419,106​
2014​	August	£947,775​	£772,542​	£1,720,317​
2014​	September	£901,837​	£893,560​	£1,795,397​
2014​	October	£767,539​	£741,017​	£1,508,556​
2014​	November	£696,972​	£760,969​	£1,457,941​
2014​	December	£853,010​	£813,346​	£1,666,356​
2015​	January	£951,276​	£849,603​	£1,800,879​
2015​	February	£1,010,803​	£985,418​	£1,996,221​
2015​	March	£1,588,974​	£1,377,431​	£2,966,405​
2015​	April	£610,136​	£669,764​	£1,279,900​
2015​	May	£637,338​	£741,242​	£1,378,580​
2015​	June	£1,257,802​	£1,252,976​	£2,510,778​
2015​	July	£1,751,566​	£1,721,078​	£3,472,644​
2015​	August	£934,750​	£805,099​	£1,739,849​
2015​	September	£942,886​	£792,674​	£1,735,560​
2015​	October	£826,588​	£717,915​	£1,544,503​
2015​	November	£602,334​	£511,313​	£1,113,647​
2015​	December	£744,073​	£586,621​	£1,330,694​

 

[offthelip]

I would have thought that a simple sumif will do it for you:
=SUMIF(A$2:A2,A2,C$2:C2)
and copy it down

 

[ManUBlueJay]

I tried that, but it only works for the year you are working with.
My Formula would start on F14. I can easily sum the 2014 as they grow. How do I divide it with the corresponding range in the previous year. Jan 2014/Jan 2013. Feb 2014 should be sum of Jan and Feb/ By sum of Jan and Feb 2013............

 

[jasonb75]

Try this in F14, fill right and down.

=SUMIF($A$14:$A14,$A14,$C$14:$C14)/SUMIF($A$2:$A2,$A2,$C$2:$C2)

 

[offthelip]

or possibly:
=SUMIF(A$2:A2,A2,C$2:C2) / SUMIF(A$2:A2,A2-1,C$2:C2)

 

[ManUBlueJay]

Thank you. This works for me