To average cells based on one criteria use the AVERAGEIF function. Now press Enter key to see the result or press CtrlEnter key to stay in the formula cell. 7 Mathematical Functions used in MS Excel with Examples 1 SUM.
These functions are organised into categories text logical math etc to help you to locate the function you need from the Excel menu.
This example uses the Sign method of the Math class to determine the sign of a number. Here is a list of important Excel Formula and Function. The SUM function is probably the most common mathematical function that youll use in Excel Any basic totals and subtotals use the SUM function. This Basic Excel Formula is used to get the sum of the value in one or more cells or Range.