A simple way to sum interlaced rows in Excel

Encountered the problem of summing every other row in Excel? PHP editor Apple has carefully compiled a detailed tutorial to reveal the simple method of summing interlaced lines for you, so hurry up and learn more!

First demonstrate the normal operation, select the total row of B5:H5, and click Sum. Select B11:H11 again and sum. This method can still handle such small tables, but for some large tables with a lot of data, this seems to be inefficient. Here are the quick steps.

Select the entire table and press the shortcut key CTRL G to perform positioning operations.

Check [Null Value] in the positioning conditions.

After clicking OK, all cells in the total will be selected. Then click AutoSum or press the shortcut key ALT plus the equal sign key to perform automatic summation.

Finally, the computer will automatically calculate the total information for you.

The above is the detailed content of A simple way to sum interlaced rows in Excel. For more information, please follow other related articles on the PHP Chinese website!