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 ...