There are two ways to calculate a conditional average in Excel, both involve some logic and some special functions. Excel’s SUMIF() and COUNTIF() are two of my favorite summarizing functions and we’ve ...

Using multiple sheets in the same Excel workbook helps organize data into distinct categories. For example, you might have sales data for each of your four main departments on four separate sheets. If ...