有更好的方法吗?
我的1张纸上有18个不同的范围,其中有名字和总数。
每个范围都有一个名称列表,旁边有一个数量,底部有一个。我不能仅仅搜索完整的表,因为如果同名出现在一个范围内的每个范围内的每个数量旁边,则该名称也出现在该范围的总数旁边。
我需要查找名称并总结仅总数的数量。我目前使用的
SUMIF('NC Sign'!$C$3:$C$12,PTS!$B$20,'NC Sign'!$D$3:$D$12)+SUMIF('NC Sign'!$E$31:$E$57,PTS!$B$20,'NC Sign'!$E$31:$E$57)+SUMIF('NC Sign etc....
非常麻烦,可以使得一些非常长,缓慢的配方。有人有更好的方法吗? PS我需要在公式而不是VBA中实现这一点。
I have 18 different ranges on 1 sheet that have names and totals in them.
Each range has a list of names with a quantity next to it and a total at the bottom. I can't just search the complete sheet due to the fact that if the same name appears next to every quantity in one range that name also appears next to the total for that range.
I need to look up the names and sum the quantities of just the ranges not the totals. I currently use
SUMIF('NC Sign'!$C$3:$C$12,PTS!$B$20,'NC Sign'!$D$3:$D$12)+SUMIF('NC Sign'!$E$31:$E$57,PTS!$B$20,'NC Sign'!$E$31:$E$57)+SUMIF('NC Sign etc....
This is very cumbersome and makes for some extremely long, slow formulas. Does anyone have a better way to do this. P.S. I need this to be accomplished in formula not VBA.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
也许您可能会使用它
,但我不知道它有多慢。
Maybe you may use this
But I don't know about how slow it is.