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?
Google-sheets – How to get the SUM total value to appear in cell vs the formula
formulasgoogle sheetskeyboard shortcuts
Related Topic
- Google-sheets – How to create a formula in Google Sheets that can sum specific cells based on multiple criteria
- Google Sheets Formulas – Sum Values Inside Multiple Brackets in a Single Cell
- Google Sheets – Sum Values Based on Key in Single Cell
- Google-sheets – Suming values in a column if value in cell next to it matches another cell
- Google Sheets – Apply Formula to Each Cell in Column Before Summing
- Google-sheets – Google Sheets Formula – Trying to Sum, based on multiple cell criteria
- Google-sheets – How to get a cell reference used in a cell for use in a different formula
- Google-sheets – In Google Sheets or Excel, how can I write a formula to SUM() a range based on the criteria that none of the respective cells are blank
Best Answer
press
CTRL
+`
to trigger result overviewto turn this:
into this:
and vice versa