How to Sum Cells If Not Blank in Google Sheets

To sum cells if they are not blank in Google Sheets, you can use the SUMIF function. The SUMIF function allows you to sum cells based on specific criteria. In this case, the criteria will be cells that are not blank.

Here are the steps to sum cells if they are not blank:

1. Open your Google Sheet or create a new one.
2. Click on the cell where you want the result of the sum to be displayed.
3. Type the formula =SUMIF(range, "<>", ""), where range is the range of cells you want to sum if they are not blank.

For example, if you want to sum cells A1 to A10 if they are not blank, the formula would look like this:

=SUMIF(A1:A10, "<>", "")

Press Enter to get the result.

Example

Suppose you have the following data in cells A1 to A10:

10
20

30
40

50
60

There are some blank cells in the range. To sum the cells that are not blank, follow these steps:

1. Click on the cell where you want the result (let's say B1).
2. Type the formula =SUMIF(A1:A10, "<>", "") in cell B1.
3. Press Enter.

The result in cell B1 will be 210, which is the sum of all the non-blank cells in the range A1:A10.