How to Use the Countif & Countifs Functions in Excel. Microsoft Excel 2010 is a powerful spreadsheet program that business owners can utilize to track everything from employee's schedules to ...

TEXTBEFORE and TEXTAFTER are a few more of my favorite Excel functions to clean messy spreadsheets. Excel's newer text ...

To count colored cells in Microsoft Excel, you may use the Find and Select tool or the Excel Filter and SUBTOTAL() function.

Learn how to count blank or empty cells in Excel and Google Sheets. Use COUNTBLANK , COUNTIF or SUMPRODUCT function to count blank cells in spreadsheet.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

The SUMIF Function in Excel There are also more complicated functions in Excel that can sum or count values when certain criteria are met.