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], ...)
To get the average of a set of numbers, excluding or ignoring zero values, use the AVERAGEIF function. In the example shown, the formula in E6 is: =AVERAGEIF(B6:D6,<>0) How this formula works. AVERAGEIF performs an average based on criteria you supply. In this example, the criteria supplied is <>0, which means not equal to zero. Like AVERAGE , AVERAGEIF automatically ignores blank cells and text.