MID, and RIGHT To help you use Excel more effectively (and save a ton of time), we've compiled a list of essential formulas, keyboard shortcuts, and other small tricks and functions you should know. NOTE: The following formulas apply to the latest version of Excel. If you're using a slightly older version of Excel, the location of each feature mentioned below might be slightly different.
SUM All Excel formulas begin with the equals sign, =, followed by a specific text tag denoting the formula you'd like Excel to perform. The SUM formula in Excel is one of the most basic formulas you can enter into a spreadsheet, allowing you to find fax number list the sum (or total) of two or more values. To perform the SUM formula, enter the values you'd like to add together using the format, =SUM(value 1, value 2, etc). The values you enter into the SUM formula can either be actual numbers or equal to the number in a specific cell of your spreadsheet. To find the SUM of 30 and 80, for example, type the following formula into a cell of your spreadsheet.
Press "Enter," and the cell will produce the total of both numbersTo find the SUM of the values in cells B2 and B11, for example, type the following formula into a cell of your spreadsheet: =SUM(B2, B11). Press "Enter," and the cell will produce the total of the numbers currently filled in cells B2 and B11. If there are no numbers in either cell, the formula will return 0. Keep in mind you can also find the total value of a list of numbers in Excel. To find the SUM of the values in cells B2 through B11, type the following formula into a cell of your spreadsheet: =SUM(B2:B11). Note the colon between both cells, rather than a comma. See how this might look in an Excel spreadsheet for a content marketer, below: sum-formula-excel.