Calculation of YTD Data

[Chimero]

Hello,

I have attached an excel sheet with some data in it. what I actually want to happen is that whenever i select a month from the drop down menu, the formula should calculate the sum of all the data in cell B. for eg, when i select Feb, it should calculate Jan + Feb and give me the value there.

Thanks a ton in advance.

regards,

[EllBol]

Assuming that your drop down dates are in cell I2

Try this formula:

=SUMIF(A:A,"<="&I2,B:B)

I am assuming that your data starts in Jan-11 and there is no prior data in the sheet!

EllBol

[Chimero]

Bro, works exactly like I wanted it to. Thanks a ton. Appreciate all the help.

regards,