Adding categories in Excel with SUMIF

If you need to get the SUM of only specific items within a column in Excel, the SUMIF function will make things simple.

 

In this spreadsheet example, each specific type of fruit can be totaled separately. 
To total all the apples,  =SUMIF(B2:B8,"apple",C2:C8)
The word apple must be in quotes for the function to work.
To calculate the total bananas and oranges sold, simply change "apple" to "banana" or "orange" in your SUMIF function.  See example images below

How to Repeat Header Rows in Excel Spreadsheets

To repeat a set of header rows in Excel

• Go to File > Page Setup
• Click on the "Sheet" Tab
  
• Click on the pyramid icon next to the "rows to repeat at top" field.
• Select the cells to be repeated
• Click on the pyramid icon again to return to the Sheet options
• Click OK.

Here's a screenshot from the Office 2004 Mac version.

How to Print Empty Cells with Borders in Excel

Normally, Excel will not print empty cells, and will only the print the header row that contains data in the cell. Here's how Excel can print empty cells with gridlines/borders

• Add the Borders
• Select the cells to be printed
• Go to File > Print Area > Set Print Area
• Go to File > Print and now all the cells that were selected will display in the print preview.