web analytics

Inserting Function

Each function has the same framework. SUM (A1:A4), for example. This function’s name is SUM. The part between brackets implies that as input, we give Excel the range A1:A4. This feature adds values to the A1, A2, A3 and A4 cells. Which function and which arguments to use for each task is not easy to remember. Fortunately, this is supported by the Insert Function feature in Excel.

Execute the following steps to insert a function.

1. Choose a cell.

2. Hit the Insert Function button.

The dialog box for ‘Insert Function’ appears.

3. Check for a feature or choose a feature from a category. For example, choose COUNTIF from the Statistical group.

Error! Filename not specified.

4. The click OK.

The dialog box for ‘Function Arguments’ appears.

5. Click in the Range box then select the range A1:C2.

6. Click in the Criteria box and type >5.

7. Then click OK.

Outcome. The COUNTIF function

 counts greater than 5 cells.

Note: simply type =COUNTIF (A1:C2,”>5″) instead of using the Insert Function feature. Upon arriving at: =COUNTIF (instead of typing A1:C2, simply select the A1:C2 range.