Understanding Lyric Poems through Tone and Metaphor - Lyric poetry is a form of poetry where the author expresses his/her feelings and thoughts in a brief, compressed manner (Stanford). It is the most popular and common type of poetry today, conveying the authors emotions to the readers (Grimes).
This article describes the formula syntax and usage of the AVERAGE function in Microsoft Excel. Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers. AVERAGE(number1, [number2], ...)
In this AVERAGEIFS formula: 1  Average_range is B2:B8 (cells that you want to average if both conditions are met); 2  Criteria_range1 is A2:A8 (Items column) and criteria1 is banana; 3  Criteria_range2 is B2:B8 (Sales column) and criteria2 is >100.