为什么我的SUMIFS公式给出了不正确的论点?

dsprenger

我正在制作一份指标表，为仪表板提供动力。我想总结一下我们每个化学家和每个项目类别的努力值。

我的范围是:

{MasterLead}:列示项目化学家

{MasterEffort}:每个项目的努力值列

{MasterRDCat}:项目类别列

我正在尝试使用以下公式:

=条件求和({MasterEffort}, {MasterLead},(电子邮件保护)， {MasterRDCat}， ="PMO")

据我所知，这个公式将对{MasterEffort}中的努力值求和，其中{MasterLead}是该行的化学家，{MasterRDCat}是PMO。

在使用COUNTIF时，我能够处理这些范围，但在使用SUMIF时，我遇到了很多麻烦。谢谢你！

保罗新来的

该错误是否存在于公式引用的任何单元格中?

你能提供你正在使用的COUNTIFS公式吗?

dsprenger

Is that error present in any cell being referenced by the formula?<\/p>

Are you able to provide the COUNTIFS formula that you have working?<\/p>","bodyRaw":"[{\"insert\":\"Is that error present in any cell being referenced by the formula?\\n\\nAre you able to provide the COUNTIFS formula that you have working?\\n\"}]","format":"rich","dateInserted":"2023-05-01T18:59:55+00:00","insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-12T03:09:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/373935#Comment_373935","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/373935#Comment_373935

没有。任何东西都可以毫无问题地引用到其他地方。

这里有一个相应的COUNTIFS: =COUNTIFS({MasterLead}，(电子邮件保护)， {MasterRDCat}， ="PMO")

保罗新来的

仔细检查{MasterEffort}范围，以确保它实际上只覆盖一列(并覆盖整个列)与其他两个范围相同。

dsprenger

Double check your {MasterEffort} range to ensure that it is in fact only covering one column (and covering the full column) the same as the other two ranges.<\/p>","bodyRaw":"[{\"insert\":\"Double check your {MasterEffort} range to ensure that it is in fact only covering one column (and covering the full column) the same as the other two ranges.\\n\"}]","format":"rich","dateInserted":"2023-05-01T20:26:03+00:00","insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-12T03:09:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/373956#Comment_373956","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/373956#Comment_373956

我又检查了一遍。然而，今天似乎工作得很好。我不知道是什么改变了，但我接受了。

谢谢你的帮助!

保罗新来的

它可能只是后台的一些潜在数据。很高兴它现在为你工作了。