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
1
2	Dec-19		160,949
3
4	Jan-19	Feb-19	Mar-19	Apr-19	May-19	Jun-19	Jul-19	Aug-19	Sep-19	Oct-19	Nov-19	Dec-19
5	22,377	17,838	20,319	13,009	10,393	11,688	10,152	8,920	10,869	12,057	11,316	12,011
6

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula C2 =SUMIFS(A5:L5,A4:L4,"<="&A2) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>