CSE 2111 Lecture Notes - Lecture 3: Boolean Expression

• School: Ohio State University
• Department: Computer Science & Engineering
• Course: CSE 2111
• Professor: Clair Farris

Document Summary

Counts the number of items in a range that meet some specific criteria: =countif(range, criteria) Surround boolean expression in quotes and type & before the cell reference. Counts the number of items in a range (using multiple criteria and multiple ranges) that meet some specific criteria: all criterion must be true for the cell to be counted, =countifs(criteria_range1, criteria1, criteria_range2, criteria2) Syntax rules for the criteria are the same as countif. Sums the number of items in a range that meet specific criteria. =sumif(criteria_range, criteria, sum_range: criteria_range: a continuous range, criteria: determines what cells to sum, sum_range: if criteria is met, the computer will sum the corresponding entry in this range, same criteria syntax as countif. =averageif(criteria_range, criteria, average_range: averages the number of items in a range that meet a specific criteria. Sums a range (using multiple criteria and multiple ranges) that meet some specific criteria: all criterion must be true for the cell to be summed.