how to automatic adding up 12 rows for one year, and 48 rows for therest of year
 

Is there a function that I can use to automatic add up 12 rows for one
year figure, since the beginning number of the month always changing
each month?

how to automatic adding up 12 rows for one year, and 48 rows forthe rest of year
 

If numbers start at row 2 change c1 to c2
=SUM(OFFSET(C1,0,0,MATCH(999999,C:C,1)-11,1))

On Dec 13, 12:04*pm, Cindy Wang wrote:
Is there a function that I can use to automatic add up 12 rows for one
year figure, since the beginning number of the month always changing
each month?