in cell E2, because we're telling Excel that we ultimately want to find an average, and we're also using the INDIRECT function to tell Excel where to look to calculate this average.

Excel functions, or formulas, lie at the heart of the application’s deep well of capabilities. Today we’ll tackle IF statements, a string of commands that determine whether a condition is met ...

To learn more about this function, read Use SUMIFS() to sum by multiple conditions in Excel. The downloadable demo file includes the SUMIFS() functions. (This function is new to Excel 2007, so it ...