Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
So I have created a spreadsheet to add cells =SUM(B2:B20) ... When I hit enter the sum value should be in the cell I created the formula but instead, I have just the formula after hitting enter. How can I get the actual Sum total?
press CTRL + ` to trigger result overview
to turn this:
and vice versa
Required, but never shown