3

Sheet 1 has numeric values in the B column. I'd like to sum them into a single value within Sheet 2, preferably without having to copy them individually first.

According to the docs, I can copy a single value by doing this:

=Sheet1!B1

And that works great! But I'm looking to do a little more -- something like this:

=SUM(Sheet1!B1:Sheet1!B5)

Unfortunately, when I use that formula, I get #ERROR! and it says "Formula Parse Error."
How can I refer to a range in another sheet, not just a single cell?

4

You should refer to the sheet name only once, so:

=SUM(Sheet1!B1:B5)

returns the sum of the range B1:B5 in Sheet1.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.