CSE 1113 Lecture 2: COUNTIFs/SumIFs/AVERAGEIFs/LARGE/SMALL/RANK/SUMPRODUCT

• School: Ohio State University
• Department: Computer Science & Engineering
• Course: CSE 1113
• Professor: Jeff Buser

Document Summary

All criterion must be true in order for the cell to be counted. Sum_range: if criteria is met, the computer will sum the corresponding entry in this range. Averages the number of items in a range that meet a specific criteria. Sums a range using multiple criteria/ranges that meet a specifc criteria. All criterion must be true in order for the cell to be summed. Sum_range: range to sum if criterion are met. All criterion must be true in order for the cell to be averaged. Returns the largest value in a range, based on the k argument. K: the position (from the largest) in the array(range) Returns the smallest value in a range, based on the k argument. K: the position (from the smallest) in the array (range) Returns rank of a number in a lit of numbers. Number: the number whose rank you want to find. Ref: the array or range of values to rank.