Adding Cells In Excel Mac Versions Of

He has over two years of experience writing and editing technology-related articles.

Adding Cells In Excel Mac Versions Of

You can use the SUM command on both Windows and Mac versions of Excel to do so.

In order to include all of the cells in the longest column, youll need to know to which row the column extends.

If youre adding the A column and the B column, for example, your beginning column is the A column and your ending column is the B column.

Click the cell in which you want to display the sum of your columns.

In the parentheses, type in the beginning columns top cell number, type a colon, and type in the ending columns letter along with the longest columns ending row.

Type the top cell in the column, a colon, and the bottom cell in the column into the parentheses.

Once you have the sum of each column below the columns in question, you can proceed.

Click the cell in which you want to display the sum of the columns youre adding together.

You can do this by entering each cells letter and number into the SUM command.

Keep in mind you may have to manipulate the formula in the new cell if the columns are not the same length.

For example, to add cells A1, A2, A3, A4, and A5 together, you would type SUM(A1:A5) into an empty cell.

By continuing to use our site, you agree to our cookie policy.

If you really cant stand to see another ad again, then please consider supporting our work with a contribution to wikiHow.

Adding Cells In Excel For Mac