Excel Forum

Excel Magic Trick 371: Average Time Between Customer Orders AVERAGEIF & AVERAGE IF

See how to calculate the average time between orders for individual customers by adding a new column to the data set with an IF function formula, then use IFERROR and AVERAGEIF (Excel 2007 functions) or AVERAGE and IF function array formula (Excel 2003 formula).
Also see these videos:
Excel Magic Trick 167p1 IF function formula: 12 Examples!
Excel Magic Trick #180: COUNTIF function formula 21 Examples
Excel Magic Trick #35: New Excel 2007 AVERAGEIFS function
Excel Magic Trick #32: New 2007 IFERROR function
Excel Magic Trick #145 p3 AVERAGE IF before 2007 Excel

Got a Question? Ask it Here in the Forum.