sumifs 汇总_空标准单元格的SUMIFS公式

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列中的值与当前行