Google Spreadsheet: Sum of all number values in a row? [closed]

Question

I have a google spreadsheet with people's names and zeroes or ones, like this:

ODP    0    1    1    0    0    0    1    0
OMG    0    1    0    0    0    1    1    0
MJK    1    1    1    1    0    0    0    0

In another spreadsheet, I want to use formulas to create everyone's totals.

ODP    3
OMG    3
MJK    4

How can I do this?

Currently, I have it set up like this for the name

='Sheet1'!A2

And this for the total:

=SUM('Sheet1'!B2:I2)

However, this requires me to manually increase the domain of the SUM every time new data is added. How can I select all the numeric values in Row 2 of Sheet1?

Answer 1

=SUM('Sheet1'!2:2)

will give you the up-to-date numeric sum of Row 2 of Sheet1.

Answer 2

If all the row has is the names and the numbers this will work:

='Sheet1'!sum(1:1)

for row one and then you can copy and past allowing relative rows to move it.

Note, this only works if the name and the numbers are all that is in that row. If you have more numbers further to the right it will include them