sumifs 汇总
I recently learned about The 100-Day Project (#The100DayProject), in which you work on making something every day, for 100 days. Would Excel formulas (#100DaysOfXL) be considered an artistic project? Maybe not, but I had fun working on this SUMIFS formula with empty criteria cells!
我最近了解了100天项目(#The100DayProject),在其中您每天要制作100天的东西。 Excel公式(#100DaysOfXL)是否被视为艺术项目? 也许不是,但是我很高兴使用空标准单元格来处理这个SUMIFS公式!
空标准的SUMIFS公式 (SUMIFS Formula With Empty Criteria)
Someone emailed to ask how they could ignore one criterion in a SUMIFS formula, if that cell is empty. Here is the original formula:
有人通过电子邮件询问他们如何忽略SUMIFS公式中的一个条件(如果该单元格为空)。 这是原始公式:
=SUMIFS(D$2:D2,B$2:B2,B2,C$2:C2,C2)
= SUMIFS(D $ 2:D2,B $ 2:B2,B2,C $ 2:C2,C2)
It sums all the values in column D, starting in row 2, and down to the current row, where:
它将D列中的所有值相加,从第2行开始,一直到当前行,其中:
- values in column B match B in the the current row, B列中的值与当前行