Formula for YTD (year to date)

[EduPAz]

Hi:

Can someone please help me with this?

I have the monthly sales organized in this way:


Jan-19 (Column A), Feb-19 (Column B), Mar-19 (Column C), ...., Dec-19(Column L)

I would like to calculate the YTD (year to date) sales based on a picking list (I now how to do the picking list).

For example, when I select Jan-19 in the picking list, I should get the sales from Jan-19. If I select Jun-19, I should get the sales from Jan-19+Feb-19+Mar-19+Apr-19+May-19+Jun-19.

Thanks!

Edu

 

[Toadstool]

Hi EduPAz,

The selection cell is A2 and the results are in C2

	A	B	C	D	E	F	G	H	I	J	K	L

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]Dec-19[/TD]
[TD="align: right"][/TD]
[TD="align: right"]160,949[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]Jan-19[/TD]
[TD="align: right"]Feb-19[/TD]
[TD="align: right"]Mar-19[/TD]
[TD="align: right"]Apr-19[/TD]
[TD="align: right"]May-19[/TD]
[TD="align: right"]Jun-19[/TD]
[TD="align: right"]Jul-19[/TD]
[TD="align: right"]Aug-19[/TD]
[TD="align: right"]Sep-19[/TD]
[TD="align: right"]Oct-19[/TD]
[TD="align: right"]Nov-19[/TD]
[TD="align: right"]Dec-19[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]22,377[/TD]
[TD="align: right"]17,838[/TD]
[TD="align: right"]20,319[/TD]
[TD="align: right"]13,009[/TD]
[TD="align: right"]10,393[/TD]
[TD="align: right"]11,688[/TD]
[TD="align: right"]10,152[/TD]
[TD="align: right"]8,920[/TD]
[TD="align: right"]10,869[/TD]
[TD="align: right"]12,057[/TD]
[TD="align: right"]11,316[/TD]
[TD="align: right"]12,011[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C2
[/TH]
[TD="align: left"]=SUMIFS(A5:L5,A4:L4,"<="&A2)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]