代码之家 › 专栏 › 技术社区 › MarioS

为什么这个SUMPRODUCT抛出一个错误?结构正常,底层列没有错误

excel

MarioS · 技术社区 · 6 年前

我正在整理一个 SUMPRODUCT 公式。我知道公式的结构是正确的,因为如果我改变公式的最后一部分,它就可以正常工作了。

专栏 Table1[Milestone Date - Started] 似乎是个问题,但为什么呢?它只包含日期,不包含错误或空格。

=SUMPRODUCT(
--(Table1[MS more than 40 days] = "Dead"),
--(MONTH(Table1[Milestone Date - submittal]) = MONTH(Table1[Disb Date for loans that have a Closing Date])),
--(YEAR(Table1[Milestone Date - submittal]) = YEAR(Table1[Disb Date for loans that have a Closing Date])),
--(DAY(Table1[Milestone Date - submittal NW]) = Y$36),
--(Table1[Disbursement Date] >= WORKDAY(EOMONTH(43317, 1), -4)))

但是这个公式有一个错误,唯一的区别是最后一行:

=SUMPRODUCT(
--(Table1[MS more than 40 days] = "Dead"),
--(MONTH(Table1[Milestone Date - submittal]) = MONTH(Table1[Disb Date for loans that have a Closing Date])),
--(YEAR(Table1[Milestone Date - submittal]) = YEAR(Table1[Disb Date for loans that have a Closing Date])),
--(DAY(Table1[Milestone Date - submittal NW]) = Y$36),
--(Table1[Disbursement Date] >= WORKDAY(EOMONTH(Table1[Milestone Date - Started], 1), -4)))