Welcome to Coda!
Ah I think this is a pretty typical trap for new coda users, the solution is simple! Transpose your spreadsheet 
Generally, making row-specific calculations is not recommended in Coda, if you feel the need to do that then you might want to consider a new data structure. To be honest this makes a lot of sense once you get used to it
