¿Cómo Utilizar la Función SUMA? | Funciones de Excel 365

How to Use the SUM Function in Excel

Introduction to the SUM Function

• The video introduces viewers to using the SUM function in Excel, demonstrating its application on a simple table with columns and rows.

Methods for Using the SUM Function

• The first method involves selecting the cell immediately after the last entry you want to sum (e.g., cell B5), navigating to the "Formulas" tab, and finding the "AutoSum" button.

• Instead of clicking directly on "AutoSum," users can click on a dropdown arrow next to it, revealing five commonly used functions. Selecting "SUM" automatically generates a formula that includes an equal sign and parentheses with suggested cells.

Manual Entry of the SUM Function

• Users can also manually enter the function by typing "=" followed by "SUM." A tip is provided: it's not necessary to type out the entire function name; users can navigate through suggestions using arrow keys and press Tab to complete it.

• After selecting cells for summation, pressing Enter will execute the sum without needing to close parentheses.

Applying Functions Across Multiple Columns

• When applying the same function across multiple columns, users can drag from one corner of a filled cell downwards or sideways. This action replicates the SUM function while maintaining relative references.

• The video concludes by emphasizing that this method allows for efficient summation of all specified cells as parameters within Excel.