I am hoping someone could help me. I am trying to figure out a formula that will add the 5th cell in each row of a Spreadsheet I have, currently I have =J5+O5+T5+Z5+...+IO5, but I am needing to add lots more values and I do not want to have to keep updating the formula.

I have asked a few people I know but no one can seem to help.

Is there an IF statement I can use and specify the cell I want it to go upto?

Please help