The Sumif function adds all items that meet a certain criteria. The formula appears in the Formula B ar and the result of the function appears in the cell you selected.Д®XAMPLE: The formula should look something like =COUNTIF(C2:C11,'senior') with C2:C11 being the range, and 'senior' the criteria. In the Criteria text box, type the appropriate criteria, such as the numerical range, expression (e.g., >2), or text value.Д®XAMPLE: To count the number of students with a class rank of 'senior,' type senior. NOTE: These are the cells which will be analyzed to see if they meet the criteria you select. Within your worksheet, select the range of cells to analyze.

In the Range text box, type the range of cells.

The Function Arguments dialog box appears. On the Formula B ar, click Insert Function.ДЇrom the Or select a category pull-down list, select All or Statistical.ДЇrom the Select a function scroll box, select Countif. Select the cell where you want the result of the function to appear.ДЇrom the Formulas tab, in the Function Library group, click Insert Function. This is useful when determining the number of entries within a certain range (e.g., test scores), or the number of entries that equal a certain value (e.g., class rank of 'junior' or 'senior'). This criteria can be a number range or a word. The Countif function counts the number of items that meet a certain criteria. Sumif adds all items that meet a certain criteria. Countif counts the number of items that meet a certain criteria. This article is based on legacy software.Д¬ountif and Sumif are two functions which are helpful and very easy to use. (Archives) Microsoft Excel 2007: Functions: Countif and Sumif

Excel sumif