MS Excel | Technical Communication Center

How to Calculate Average Number of Items Sold and Average Revenue Generated by a Salesperson in a Transaction by Using MS Excel’s AVERAGEIF Function

Tweet © Ugur Akinci

Imagine you have the following sales data:

How can we find the average number of items sold by a salesperson in an average sales transaction?

The formula is:

AVERAGEIF = ([RANGE_NAME],”Name”,[AVERAGE_RANGE])

This formula will find the average of the second range for every “name” mentioned in the first range.

More [...]

Imagine you have a continuum of values in a MS Excel range, like the student grades in a class.

Here is how you can color each cell automatically so that at one look you can tell which grades are HOT and which are not.

(1) Select the data (cell) range. In [...]

Changing the width of a column to accommodate all text in a single line is something I do frequently while working with MS Excel worksheets.

After a while it gets tiresome to select Format > AutoFit Column Width from the ribbon all the time.

So here is a wonderful Windows short [...]