In this article I am going to show off five top Excel tricks for making your spreadsheets sing and to help edit and refine your sales and commissions spreadsheet. These tricks make it easier to create ...

How to reference cells with the COUNTIF function in Excel Your email has been sent Use COUNTIF to count values in a range that meet a certain condition and return a specified number to the cell.

I select columns A-H in my spreadsheet and use the filter. I can now sort and filter the data by the various columns: This dialog box lets me sort the data by rows, or display only some rows to look ...