Basic Google Sheets Formulas: A Step-by-Step Guide

Introduction

This guide will provide you with a clear understanding of how to use basic formulas in Google Sheets. By following the steps outlined below, you will learn how to calculate the total number of units booked in a sample Profit and Loss (P&L) report.

Step-by-Step Instructions

Opening the Google Sheets Example

First, we will look at a sample P&L report in Google Sheets.

Selecting the Cell for the Formula

To begin, you need to select the cell where you want the results of your formula to be displayed. Click on the cell to highlight it.

Entering Edit Mode

Double-click on the selected cell to enter the edit mode.

Starting the Formula

To add the total number of units booked, start by typing the equal sign = into the cell.

Using the SUM Function

Next, type SUM( to begin the sum function. Google Sheets will often auto-suggest this function for you.

Specifying the Range of Cells

You need to specify the range of cells you want to include in your total. In this case, we want to sum the values from D2 to D10.

Completing the Formula

Close the parenthesis to complete the formula. Your formula should look like this: =SUM(D2:D10).

Viewing the Result

Press Enter to execute the formula. The total of the numbers from D2 to D10 will now be displayed in the cell.

Editing the Formula

If you need to edit the formula later, simply double-click on the cell containing the formula, and make your changes as necessary.

Conclusion

By following the steps outlined in this guide, you should now be able to use basic formulas in Google Sheets effectively. You have learned how to sum a range of cells and how to edit your formula when needed. With practice, you’ll become proficient in utilizing Google Sheets for your data analysis needs.