Michael,

As I do not know the layout of your data this will be a little lon
winded.

Assuming the last years figures are in cells b2:b13 and this year
figures are in cells c2:c13 then the formula
=IF(C20,SUM($B$2:B2),"") entered in cell d2 and copied down for th
whole of the list will sum the values in column b starting from b2 t
the current row if there is a value in the same row column c

--
Message posted from http://www.ExcelForum.com