Back to Blog
![]() ![]() Specify the range to check against the 2nd condition (C3:C15 - scores).Express the 1st condition ("math" or F3 - the target item enclosed in quotation marks or reference to the cell containing the item).Specify the range to check against the 1st condition (B3:B15 - items).To accomplish the task, you build an AVERAGEIFS formula with two criteria: You aim to find an average score in a specific subject ignoring zeros. Supposing some students did not take tests in certain subjects and have zero scores. In essence, you use AVERAGEIFS similarly to AVERAGEIF, except that more than one condition can be tested within a single formula. The first pair is required, subsequent ones are optional. It can be supplied in the form of a number, logical expression, text value, or cell reference.ġ to 127 criteria_range / criteria pairs can be supplied. ![]()
0 Comments
Read More
Leave a Reply. |