=sum 中的多个条件
Phone number Provider Duration (min)
1001 Fastcom 2
1002 Fastcom 1
1004 Mobilecom 4
1008 Telecom 5
1001 Fastcom 3
1001 Fastcom 2
1003 Telecom 3
1004 Mobilecom 2
1008 Telecom 6
1002 Fastcom 1
我想用一个公式来计算服务提供商是电话号码1001的提供商的通话时长总和。我希望这个修订版本比以前的版本更清晰。再次感谢所有关注的人。
Phone number Provider Duration (min)
1001 Fastcom 2
1002 Fastcom 1
1004 Mobilecom 4
1008 Telecom 5
1001 Fastcom 3
1001 Fastcom 2
1003 Telecom 3
1004 Mobilecom 2
1008 Telecom 6
1002 Fastcom 1
I want to use one formula to get the sum of the duration of calls whose service provider is the provider for the phone number 1001. I hope this revised version is clearer than the previous one. Again, thanks to all who paid attention.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
有 14 行。 A 列包含从 1 到 14 的数字。B 列包含人员姓名（可能重复）。 C 列包含他们喜欢的季节（可能超过 1 个），D 列包含他们在该特定季节进行运动的天数。我需要一个公式来获取 Adam 喜欢的季节（实际上是春季和秋季）进行运动的天数
假设第 2 行到第 15 行中的数据，请尝试以下数组公式
< code>=SUM(IF(ISNUMBER(MATCH(C2:C15,IF(B2:B15="Adam",C2:C15),0)),D2:D15))
确认CTRL+SHIFT+ENTER
There are 14 rows. Column A contains numbers from 1 to 14. Column B contains Names of people(maybe repeated). Column C contains their preferred seasons (possible more than 1) and Column D contains how many days they do sports in that partucular season. I need one formula to get how many days are spent doing sports in the season(s) that is (are) preferred by Adam, which actually are Spring and Fall
Assuming data in rows 2 to 15 try this array formula
=SUM(IF(ISNUMBER(MATCH(C2:C15,IF(B2:B15="Adam",C2:C15),0)),D2:D15))confirmed with CTRL+SHIFT+ENTER
在一个公式中我不确定。就我个人而言，我会在 E 列的每一行中都有一个公式，该公式为
0或 D 中的值，然后您可以使用sum(e:e)来代替。In one formula I'm not sure. Personally I'd have a formula in each row of column E that is
0or the value from D, then you cansum(e:e)instead.