Click the down arrow next to the Borders button.The sum of cells C1 to C3, which is 300, appears. Type C1:C3 in the Number1 field, if it does not automatically.The Function Arguments dialog box appears. Click Sum in the Select A Function box.Choose Math & Trig in the Or Select A Category box.The sum of cells B1 to B3, which is 63, appears.Īlternate Method: Enter a Function with the Ribbon Excel will complete the function name and enter the first parenthesis.
You can double-click on an item in the AutoComplete list to complete your entry quickly. For example, arguments specify the numbers or cells you want to add.Īfter you type the first letter of a function name, the AutoComplete list appears. Arguments are values on which you want to perform the calculation. When using a function, remember the following: Not the operators, such as +, -, *, or /. Understanding Functionsįunctions differ from regular formulas in that you supply the value but The referenceĪ7,B8:B10,C9,10 refers to cells A7, B8 to B10, C9 and the number 10. A union referenceĬonsists of two or more numbers, range references, or cell addresses separated by a comma. The referenceĪ1:C3 includes cells A1, A2, A3, B1, B2, B3, C1, C2, and C3.Ī union reference includes two or more references. The reference A1:A3 includes cells A1, A2, and A3. A range reference consists of two cell addresses separatedīy a colon. Types of reference operators: range and union.Ī range reference refers to all the cells between and including the Reference operators refer to a cell or a group of cells. To use functions, you need to understand reference operators.
0 kommentar(er)
