Question

Your manager, Angelique Kidjo, has a Google Sheet where she keeps track of her weekly expenses. She has listed the expenses in Column A, rows 1-7. Angelique wants to know the total amount spent for the week. What formula would you put in the cell where you want to see the total?

Answer 1

To calculate the total amount spent for the week in Google Sheets, you can use the `SUM` function. Assuming the expenses are listed in Column A from rows 1 to 7, you would enter the following formula in the cell where you want to see the total (for example, in cell A8):

```plaintext
=SUM(A1:A7)
```

This formula will sum all the values from A1 to A7 and display the total in the cell where you entered the formula.