Excel, Data, Data Analysis, Analytics.
is the range with the values I want to add (the sales amounts.) I use SUMIF() to calculate the sales amounts for jeans. AVERAGE() AVERAGE() calculates the average of a set of numbers. In the example below, I calculated the average for the cell range A2 through A126: =AVERAGE(A2:A126) “AVERAGE”