• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

aggregate vs average

sprlvlyldy

New Member
Hello All,

can someone please give me a simple explination how the two are different? It would be greatly appriciated!!

Thank you =)
 
Good day sprivlydy


Average =arithmetic mean = total of all values divided by number of values

Aggregate = Overall total


Aggregate is frequently used when data from different sources is combined.
 
Just in case the question is about the AGGREGATE() worksheet function; MSDN information can be found here:

http://office.microsoft.com/en-gb/excel-help/aggregate-function-HA010338704.aspx


It is only available in Excel 2010 or later.
 
Back
Top