Excel AVERAGE Function Tips

Operation with condition according to the average

Using AVERAGE() and IF() formulas.

Finding minimum, maximum and average number in a list and counting the number of cells. 

Using the MIN(), MAX(), COUNT() and AVERAGE() functions on a list