Sheets: Repeat the same function on the values in a row for many rows
I have found that very often, I wish to do the same basic operation on many rows in Google Sheets. For example, I used to have a contest logger of which questions I got right when doing practice contests, and at the end of each row I would sum over all the points that I got right in that row. I would then repeat this for each new contest, a.k.a. each new row. See attached picture and ignore all of the color coding.