3 of 3
Formatting, dethank, clarified question
Vidar S. Ramdal
  • 16.1k
  • 11
  • 65
  • 79

How do I refer to a range in another sheet?

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?

soapergem
  • 539
  • 2
  • 7
  • 18