I have rows of data to which I add new values once a week. I want to sum the last 12 values in the row (the sums will be tied to charts).

I tried =sum(offset(c2,counta(12:12)-12,0,1,-12)), but it doesn't seem right (mostly because it doesn't work).

Can anyone help?

Thanks
JP