excel sumifs
In Excel 2007 and Excel 2010, you can use the new SUMIFS function to sum items using multiple criteria.
在Excel 2007和Excel 2010中,可以使用新的SUMIFS函数使用多个条件对项目求和 。
For example, sum the orders where an account status is Active, and the number of visits is greater than or equal to 10. You can type in the criteria, but it's better to use cell references, where possible.
例如,对帐户状态为“活动”且访问次数大于或等于10的订单求和。您可以键入条件,但在可能的情况下最好使用单元格引用。
I've updated the Excel SUM page on the Contextures website, to include the SUMIFS function example and video.
我已经在Contextures网站上更新了Excel SUM页面,以包括SUMIFS函数示例和视频。
观看SUMIFS视频 (Watch the SUMIFS Video)
To see the steps for creating a SUMIFS formula, and using cell reference, watch this short Excel video.
要查看创建SUMIFS公式以及使用单元格引用的步骤,请观看此简短的Excel视频。
翻译自: https://contexturesblog.com/archives/2012/02/02/excel-sumifs-sum-with-multiple-criteria/
excel sumifs