> 其他 >
英语翻译
Subtotal the data in the range B4:I19 so that at each change in Agent Last Name,a subtotal is added to the Base Cost of Trip column.Accept all other defaults in the Subtotal dialog box.Click the Level 2 outline symbol in the Outline bar to display only the totals for each agent and the Grand Total.
人气:331 ℃ 时间:2020-05-23 03:13:52
解答
英文我是不懂得,但是SUBTOTAL这个函数一般用于在挂着筛选的时候,根据筛选的内容来进行计算.输入=SUBTOTAL后,可以看到第一个参数从1-11,101-111,后面有数字所代表的意义,第二个参数是范围.例:=subtotal(9,A1:A10),代...
推荐
猜你喜欢
© 2026 79432.Com All Rights Reserved.
电脑版|手机版