如何汇总使用数据验证列表创建的给定类别的所有单元格? 在Microsoft Office Excel 2011中。
示例:在C列中,将从G列中找到的每个值求和。
在Google电子表格中,我可以使用以下公式执行此操作:
=IF(ISBLANK(F3),"",SUM(FILTER($G$3:G,$F$3:F=B3)))
但在Microsoft Excel中它不起作用。
How can I sum all the cells of a given category, created with Data Validation List? In Microsoft Office Excel 2011.
Example: In the C column, sum every value from that is found from the G column.
In Google Spreadsheet, I can do this with this formula:
=IF(ISBLANK(F3),"",SUM(FILTER($G$3:G,$F$3:F=B3)))
But in Microsoft Excel it doesn't work.
最满意答案
看一下Excel中的SUMIF公式。 如果您需要多个条件,可以使用SUMIFS公式。
Excel等价物将是这样的:
=IF(ISBLANK(F3),"",SUMIF($F$3:$F$100000,B3,$G$3:$G$100000))Take a look at the SUMIF formula in Excel. and if you need multiple criteria you can use the SUMIFS formula.
The Excel equivalent would be something like this:
=IF(ISBLANK(F3),"",SUMIF($F$3:$F$100000,B3,$G$3:$G$100000))更多推荐
发布评论