Excel Forum
Similar Content
VBA IF Statement in Excel Macros
Tutorial: IF statements allow you to make decisions in your Macros and VBA in Excel. An IF statement...
Excel Formatting for Zip Codes and Phone Numbers
Tutorial: Display numbers in Excel as zip/postal codes and phone numbers in order to make them easi...
Wildcards in Excel
Tutorial: Wildcards are characters that allow you to make more robust functions, searches, and filt...



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.