This browser does not support basic Web standards, preventing the display of our site's intended design. May we suggest that you upgrade your browser?
Countif and Sumif are two functions which are helpful and very easy to use. Countif counts the number of items that meet a certain criteria. Sumif adds all items that meet a certain criteria.
The Countif function counts the number of items that meet a certain criteria. This criteria can be a number range or a word. 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").
Open the desired worksheet
Select the cell where you want the result of the function to appear
From the Formulas tab, in the Function Library group, click INSERT FUNCTION
OR
On the Formula Bar, click INSERT FUNCTION
The Insert Function dialog box appears.
From the Or select a category pull-down list, select All or Statistical
From the Select a function scroll box, select COUNTIF
Click OK
The Function Arguments dialog box appears.
Click RESTORE DIALOG
In the Criteria text box, type the appropriate criteria, such as the numerical range, expression (e.g., >2), or text value
EXAMPLE: To count the number of students with a class rank of "senior," type senior
Click OK
The formula appears in the Formula Bar and the result of the function appears in the cell you selected.
EXAMPLE: The formula should look something like =COUNTIF(C2:C11,"senior") with C2:C11 being the range, and "senior" the criteria.
The Sumif function adds all items that meet a certain criteria. For example, you could add all the scores of students with a class rank of "senior."
Open the desired worksheet
Select the cell where you want the result of the function to appear
From the Formulas tab, in the Function Library group, click INSERT FUNCTION
OR
On the Formula Bar, click INSERT FUNCTION
The Insert Function dialog box appears.
From the Or select a category pull-down list, select All or Math & Trig
From the Select a function scroll box, select SUMIF
Click OK
The Function Arguments dialog box appears.
Click RESTORE DIALOG
In the Criteria text box, type the appropriate criteria, such as the numerical range, expression (e.g., >2), or text value
EXAMPLE: If you would like to add the test scores of the students with a class rank of "senior," type senior
Click RESTORE DIALOG
Click OK
The formula appears in the Formula Bar and the result of the function appears in the cell you selected.
EXAMPLE: The formula should look something like =SUMIF(C2:C11,"senior") with C2:C11 being the range and "senior" being the criteria.