Excel 2019 Functions: 70 Top Excel Functions Made Easy (Excel 2019 Mastery Book 3) by George Nathan

Author:George, Nathan [George, Nathan]
Language: eng
Format: epub
Published: 2019-01-30T16:00:00+00:00

Formula explanation:

=AVERAGEIF($B$2:$B$16,E2,$C$2:$C$16)

The Range argument references the Subject column B2:B16 (this has been set to absolute reference - $B$2:$B$16 ).

Tip : To convert a cell reference to an absolute reference, select the reference in the formula bar and press the F4 key. You can also type in the dollar signs manually, but it is faster and less error-prone to use F4. An absolute reference ensures the referenced cells do not change relatively when the formula is copied to other cells.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.