ifs函数是 Excel 2016的新增函数，可以取代多个if语句的嵌套，简直就是if函数的开挂版本。 有了ifs函数，在写多个条件嵌套的函数时就简单多了。

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