Excel的组版本by＆＃x2B;有
您能帮我帮助我。
如果Excel表是一个关系数据库表，这就是我要做的：
D3的值应为8，并且每当添加行时都会重新计算。我熟悉Count/Counta和Offset功能，以防其使用。枢轴表将不起作用，因为我不需要所有可能的值，只是特定的值。该解决方案应适用于Excel和Libre办公室。如果它也适用于Google表，那将会更好。
感谢您的帮助。
Could you please help me with the following.
If Excel table was a relational database table, this is what I would want to do:
D3 should have a value of 8 and be recalculated whenever rows are added. I am familiar with COUNT/COUNTA and OFFSET functions in case they need to be used. Pivot table will not work, since I don't need all possible A values, just specific one. The solution should work for both Excel and Libre Office. If it also works for Google Sheets, it will be even better.
Thank you for your help.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
以下公式应执行技巧：
= sumif（a1：b6，“ = x”，b1：b6）您可以将范围更改为所需的一切
The following formula should do the trick:
=sumif(A1:B6, "=x", B1:B6)You can change the ranges to whatever you need