英语翻译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.
问题描述:
英语翻译
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.
答
英文我是不懂得,但是SUBTOTAL这个函数一般用于在挂着筛选的时候,根据筛选的内容来进行计算.输入=SUBTOTAL后,可以看到第一个参数从1-11,101-111,后面有数字所代表的意义,第二个参数是范围.例:=subtotal(9,A1:A10),代...