this will calculate the sum of B3, B4, B5, B6, B7, B8 Press “Enter,” and the cell will produce the sum: 430. To use the SUM formula, enter the values you want to add together in the following format: =SUM(value 1, value 2,….).Įxample: In the below example to calculate the sum of price of all the fruits, in B9 cell type =SUM(B3:B8). The SUM formula in Excel is one of the most fundamental formulas you can use in a spreadsheet, allowing you to calculate the sum (or total) of two or more values. It’s on the Formulas tab, the third menu option after AutoSum.īasic Excel Formulas and Functions: 1. If retyping your most recent formula becomes tedious, use the Recently Used menu. Use Recently Used Tabs for Quick Insertion:
If your preferred group isn’t on the tab, click the More Functions option - it’s most likely hidden there.Ĥ. Click to reveal a sub-menu containing a list of functions. Navigate to the Formulas tab and select your preferred group to access this menu. This option is for those who want to quickly dive into their favorite functions. Choosing a Formula from One of the Formula Groups in the Formula Tab:
All the functions will be available in the dialogue box.ģ. To do so, go to the Formulas tab and select the first menu, Insert Function. If you want complete control over your function insertion, use the Excel Insert Function dialogue box. Using the Insert Function option on the Formulas Tab: Excel is quite intelligent in that it displays a pop-up function hint when you begin typing the name of the function.Ģ.
Typically, the process begins with typing an equal sign followed by the name of an Excel function. Typing a formula into a cell or the formula bar is the simplest way to insert basic Excel formulas. Simple insertion of the formula(Typing a formula in the cell): The formulas can be inserted into Excel using the following method: 1. Excel has over 400 functions, and the number is increasing from version to version. The more you use Excel formulas, the easier it will be to remember and perform them manually.