How to use the Sum function in Excel or Google Spreadsheet to perform a sum of numbers and end with the cell above the location of the total
Sum of Rows in Excel
| A | B | |
| 1 | Day | Sales Total |
| 2 | Monday | $1,325.47 |
| 3 | Tuesday | $1,502.69 |
| 4 | Wednesday | $1,452.14 |
| 5 | Thursday | $1,398.85 |
| 6 | Total | $5,679.15 |
=SUM(B2:OFFSET(B6,-1,0))
Excel Source: SUM OFFSET Formula
Sum of Rows in Google Spreadsheet
| A | B | |
| 1 | Day | Sales Total |
| 2 | Monday | $1,325.47 |
| 3 | Tuesday | $1,502.69 |
| 4 | Wednesday | $1,452.14 |
| 5 | Thursday | $1,398.85 |
| 6 | Total | $5,679.15 |
=SUM(INDIRECT(“B2:”&ADDRESS(ROW()-1,COLUMN(),4)))
Google Spreadsheet Source: SUM OFFSET Formula
Sorry. There isn’t one, but here’s some code that makes it easy for you to run your own survey and aggregate results using Google Forms and analyze the results using Google Sheets.
If you’re going to rebuild a company’s customer service reputation and customer experience, good foundations to start building on include transparency, accountability and brutal, yet humbling honesty. Kudos to the Comcast team for starting down this path.
We’re holding ourselves accountable and we are working hard to make real improvements across the board. While it will take us some time, we can and will do better than this.
Source: A Public Apology to Conal O’Rourke.
I’ve learned that people will forget what you said, people will forget what you did, but people will never forget how you made them feel.
Leo Widrich, from Buffer, on Bad Customer Service Support
While at a conference recently, a vendor was using a Twitter activated vending machine from Innovative Vending Solutions.
Each Twitter-activated vending machine incorporates a touch-screen interface to display the instructions to the consumer. The consumer is prompted to “tweet” a specific #hashtag to a dedicated @handle from their mobile device. Once the consumer tweets the @ and #, a product is immediately dispensed from the machine. Apparently, the machine utilizes a unique hashtag that is specific to the machine, so you have to be standing directly in front of the machine in order to utilize this functionality.