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

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`?

-

## closed as off topic by random♦Aug 8 '10 at 1:07

Questions on Super User are expected to relate to computer software or computer hardware within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.

``````=SUM('Sheet1'!2:2)
``````

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

-
but what if not all the values in `row 2` are numeric? – Rosarch Oct 17 '09 at 23:04
Then it sums up only the numbers. Sum function only evaluates the numeric values. Isn't this what you exactly want to do? – Mehper C. Palavuzlar Oct 18 '09 at 8:51

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

-