However, where they differ from the more straightforward AVERAGE function is in their ability to include or discount certain values within the calculation ... to break this formula down.