To answer this question, we will use the function COUNTIFS because we will need Excel to do a count based on two criteria: that the department is tax and the amount billed to the client is greater ...

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