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

Paste the following into a cell adjacent to the one containing the first customer's name:=IF(Sheet1!F3 = 8, "True", "False") Replace "Sheet1!F3" with the address for the cell you want Excel to check.