subtotal是什么意思,subtotal中文翻译,subtotal发音、用法及例句

•subtotal

subtotal发音

英：['sʌbtəʊtl]　　美：[sʌbˈtotl]

英：　　美：

subtotal中文意思翻译

adj.不完全的

v.小计达到

n.小计

subtotal词形变化

动词第三人称单数: subtotals/subtotals |动词过去式: subtotaled/subtotalled |动词过去分词: subtotaled/subtotalled |动词现在分词: subtotaling/subtotalling |

subtotal常见例句

1 、Gangner M. Endoscopic subtotal parathyroidectomy in patients with primary hyperparathyroidism[J]. Br Surg 1996,83(7):875.───仇明，丁尔迅，江道振等.颈部无瘢痕内镜甲状腺腺瘤切除术一例[J].中华普通外科杂志,2002,17(2):127.

2 、Methods Clinical features and processes of treatment were analyzed for 12 cases with FDGE occurred in 375 patients after subtotal gastrectomy.───方法分析375例胃大部切除术后发生的12例FDGE患者的临床特点及诊治经过。

3 、Methods:Retrospectively analyse the clinical data of 120 cases of laparoscopic subtotal choleeystectomy in complicated cases.───方法:回顾分析了120例复杂情况下行腹腔镜胆囊次全切除的临床资料及治疗效果。

4 、Patients who undergo reoperation because of early recurrent lumbar disc herniation can have clinical outcomes comparable with those of patients undergoing an uncomplicated subtotal lumbar discectomy.───因早发腰椎间盘突出需再次手术病人的临床疗效比得上那些接受了不复杂腰椎间盘次全切除术的病人。

5 、For example, suppose there is a Products On Order report that displays the subtotal of units on order for each category of product in the database.───例如,假如有一个“已订购产品”报表,该报表显示数据库中每类产品的已订购数量的分类汇总。

6 、After subtotal thyroidectomy, he still had diplopia in a certain gaze.───在接受次甲状腺全切除手术之后，复视的情形仍然存在。

7 、Eighty morphophysiological traits were studied in 55 males with a morphologically identical heterochromatin subtotal deletion of Y chromosome and in 55 males wi th a normal Y chromosome.───摘要 对55名Y染色体具有形态上相同的、异染色质几乎全部缺失的男性和55名Y染色体正常的男性 进行了80项形态生理学性状的研究。

8 、Those with unfavorable features were randomized to four or six cycles of chemotherapy plus involved field radiotherapy or subtotal nodal radiotherapy.───情况较差的患者被随机进行四疗程或六疗程化疗加相关区域放疗，或全淋巴结放疗。

9 、Methods To analyse results, methods of treatment and diagnosis and clinical manifestions in 19 cases of gastric atomy after subtotal gastrectomy from January 1990 to September 2000.───方法对1990年2月至2000年9月收治的19例胃大部切除术后功能性残胃无力症的临床表现、诊断与治疗方法与结果回顾。

10 、Method Surgical procedures,including the Whipple resection,pylorus preserving resection, total and subtotal pancreatectomies,regional pancreatectomy and the extended lymph node resection, were discussed.───方法 :讨论目前治疗胰腺癌的各种手术方法 ,包括Whipple手术、保留幽门的胰十二指肠切除术、胰腺次全和全切术、区域性胰腺切除术以及广泛的淋巴结清扫等。

11 、Creates a field called FreightPercentage, and then displays the percentage of freight charges in each subtotal.───创建一个称为“运费百分比”的字段,然后显示每个分类汇总中的运费所占的百分比。

12 、Subtotal perineal prostatectomy───会阴前列腺次全切除术

13 、For the first 11 cases, we adopted the way of removing nodule and among the rest 51 cases, 30 accepted subtotal thyroidectomy, and 21 accepted gland lobectomy.───初期11例仅行甲状腺腺瘤摘除术,后期51例根据术中探查结果30例行甲状腺次全切除,21例行腺叶切除术。

14 、Subtotal gastectomy (80.5%)was the main modus operandi.Post-operation five-year-survival rate was 86.4%and post-operation recurrence rate was 9.1%.───手术方式以胃大部切除为主(80.5%),术后5年生存率为86.4%,复发率为9.1%。

15 、Abstract ABSTRACT:Objective To study the change of the serum gastrin (GAS) and plasma motilin (MTL) levels as well as the gastric motility in gastric cancer patients after subtotal gastrectomy.───摘要 摘要：目的 研究胃大部分切除术后胃癌患者血清胃泌素(GAS)、血浆胃动素（MTL)和胃动力的变化情况。

16 、Thus, patients with follicular neoplasms are treated with subtotal thyroidectomy just to be on the safe side.───因此，对滤泡状肿瘤采取甲状腺次全切是比较安全的措施。

17 、Subtotal pericardiectomy with cardiopulmonary bypass───心包次全切除术伴心肺分流术

18 、Methods:The clinical materials were retrospectively analysed in 11 cases of gastroparesis after radical subtotal gastrectomy.───方法:回顾性分析11例根治性远端胃大部切除术后胃瘫的临床资料。

19 、The major indicatio of subtotal hysterectomy were postpartum hemorrhage, uterine inertia and placental related factors.───产后出血、宫缩乏力和**因素是子宫次全切术的主要手术指征。

20 、Like ROLLUP and CUBE, this operation adds subtotal rows into the result sets of queries with GROUP BY clauses.───与ROLLUP和CUBE一样,此操作将子汇总行添加到使用GROUP BY子句的查询结果集中。

21 、I long to vomit one of cigarettes, said: carving insects Subtotal, high aims in life.───我长长的吐了一口烟,说:雕虫小计,玩物丧志。

22 、Suppose that you want to add some text to comment the subtotal and, at the same time, have the subtotal appear in the same column as the single orders amount.───假设您需要添加一些文本以对小计进行注释,而且与此同时,让小计与单个定单量出现在同一列中。

23 、Methods Analysing the clinical effects of 11 cases of gastroplegia caused by distal subtotal gastrectomy during Feb. 1997 to May 2007 who recept expectant treatments after operation.───方法对1997年2月至2007年5月收治11例远端胃大部切除术后胃瘫进行临床分析。

24 、subtotal supracervical hysterectomy───子宫次全切除术

25 、In Adson's1 last paper in 1947, he changed from his original scalenotomy to a subtotal scalenectomy and reported 81% good improvement with a 1- to 20-year follow-up.───在Adson1947年最后的论文中，他把原来的斜角肌切除术改变为次全斜角肌切切除并在1到20年的随访后报道有81%的得到提高。

26 、Methods 68 patients with bilateral nodular goiter was treated by new method of bilateral subtotal thyroidectomy,and the effects of new method was compared with routine treatment.───方法8年中使用保留甲状腺下动脉术式,尽可能多的保留正常甲状腺组织治疗68例双侧结节性甲状腺肿与同期使用传统方法治疗结节性甲状腺肿进行比较分析。

27 、Reporting Services will calculate the sum of the values within the group and display the subtotal.───Reporting Services将计算组中各值之和并显示小计。

28 、ROLLUP adds subtotal rows into the result sets of queries with GROUP BY clauses.───ROLLUP会将子汇总行添加到使用GROUP BY子句的查询结果集中。

29 、Keywords subtotal thyroidectomy;ante carvix muscle group;───关键词甲状腺大部切除术;颈前肌群;

30 、Subtotal hysterectomy after cesarean delivery───剖宫产后次全子宫切除术

31 、METHODS The study 192 hyperthyroidism cases after subtotal thyroidectomy to observe the postoperative complications.───方法对192例甲状腺机能亢进症病人进行甲状腺次全切除术,对术后并发症进行观察。

32 、Methods 5 patients after subtotal gastrectomy and enteron reconstructed by colon were analyzed retrospectively,and several reconstructive methods were also analyzed.───方法回顾性分析5例胃大部切除术后食管癌经结肠代食管重建消化道治疗的临床病例资料,比较分析几种消化道重建术式的优缺点。

33 、The COTs had a total removal in 44 cases ((78.6%)) and subtotal removal in 12 ((21.4%)).───44例肿瘤(78.6%)获手术全切除,12例(21.4%)为次全切除。

34 、Two months later, a second subtotal cytoreductive surgery was performed and anaplastic intramedullary astrocytoma was proved by pathology results.───再经过详细检查及评估之后，第二次手术才进行肿瘤切除，组织病理报告证实为脊髓内恶性星状细胞瘤。

35 、Patients with favorable features were randomized to subtotal nodal radiotherapy or three cycles of chemotherapy plus involved-field radiotherapy.───情况较好的患者被随机进行全淋巴结放疗，或三疗程化疗加相关区域放疗。

36 、In the caesarian section group, conservative operations were performed in six patients, and subtotal hysterectomy in two.───8例剖宫产手术病人 6例行保守性手术治疗 ,2例行次全子宫切除术 ;

37 、In 14 dogs, renal artery stenosis wag produced by unilateral subtotal ligation. chromic catgut. Renovasoular hypertension developed in 12 of them.───对14条犬用手术方式结扎单侧肾动脉,12条犬产生高血压。

38 、All patients underwent resections of epidermoid cyst, 1 total resection,and 9 subtotal resections.───10例患者均行手术治疗，肿瘤全切除1例，次全切除9例。

39 、Wedge resection of venter and Subtotal hysterectomy clinic contrast analysis───子宫体楔形切除术与子宫次全切除术的临床对比分析

40 、The aim of this study was to examine the results of hand-assisted laparoscopic surgery for subtotal colectomy in the treatment of patients with STC.Method.───方法从2001年1月到2003年1月，8位至少有2年以上间歇性腹痛及便秘症状的年轻女性在本院接受手术治疗。

41 、One stage subtotal suprapubic prostatectomy───一期耻骨上前列腺次全切除术

42 、This query generates a subtotal report───以下查询将生成小计报表

43 、Objective: To compare the clinical characteristics of laparoscope assisted subtotal hysterectomy (LASH) and traditional abdominal subtotal hysterectomy (TASH).───摘要目的：比较腹腔镜辅助子宫次全切除术与传统剖腹子宫次全切除术的疗效。

44 、Congenital subtotal cataract───先天性次全内障

45 、Twenty-nine historical control patients who had undergone uncomplicated subtotal lumbar discectomy were selected.───29例接受不复杂腰椎间盘次全切除术的病人被选作为病例对照。

46 、Analysis of 25 patients with subtotal hysterectomy in cesarean section───剖宫产子宫次全切术25例分析

47 、We report a 24-year-old female with thyroid tumor who was admitted for subtotal thyroidectomy.───我们在此报告一位24岁患有甲状腺肿瘤女**人，入院接受次全甲状腺切除手术。

48 、Low vision(the older term subnormal vision has been abandoned) refers to a reduction is central acuity or a subtotal visual field loss.───低视力(多发于老年期的视力减退)表现为中心视力下降或局限性视野的缺损。

49 、Methods Of the 4 patients,2 had malignant tumor and 2 innocent tumor.Three patients received subtotal pancreas-sparing duodenectomy and 1 of them underwent it below the duodenal papilla.───方法对2例恶性肿瘤,2例良性肿瘤,行保留胰腺的十二指肠全切除术3例,乳头以下的十二指肠切除术1例。

50 、The ear cancer was treated by subtotal temporal bone resection.───中、外耳癌则实行颞骨次全切除术。

51 、After emergent management such as: intrauterine gauze packing dilatation and cuettage were failed, a subtotal hysterectomy was required to save the patient.───我们建议剖腹产时在有感染因素高之孕妇如难产者可行预防性抗生素，可以避免此少见之大出血。

52 、Inserts a subtotal for a row field or column field in an existing pivot table.───在当前数据透视表中**入列字段或行字段的分类汇总。

53 、For each purchase order an XQuery is executed that returns a formatted result of each product subtotal.───对于每个采购订单,都将执行一个XQuery,返回每个产品小计的格式化结果。

54 、Count cells in a list or Excel table column by using the SUBTOTAL function───使用SUBTOTAL函数对列表或Excel表列中的单元格进行计数

55 、Total resection was achieved in 5 cases,and subtotal resection in 13 cases.17 cases were typical chordomas and 1 case was chondroid chordomas.14 patients were fo...───14例获得随访,其中4例死亡,10例恢复正常生活。结论:颅底脊索瘤发病率低,手术全切除的难度大,需结合放射治疗。本病预后差。

56 、I'd resect rather than do a subtotal pancreatectomy.─── 与其切除整个胰脏 不如切除尾部组织

57 、Methods: Fifteen cases of cervicothoracic fracture were performed on anterior subtotal vertebraectomy at C 7,T 1,C 6,7 or C 7 T 1 segment, bone graft and Orion anterior cervical locking plate fixation in cervicothoracic spine.───方法 :对 15例颈胸段脊柱骨折、脱位的患者行颈胸段前路 C7,T1 ,C6,7或 C7-T1 椎体次全切除、植骨及 Orion锁定型颈椎前路钢板固定术。

58 、The sum of the values of the Subtotal and Freight fields or controls.───“分类汇总”和“运费”字段或控件的值之和。

59 、subtotal supraglottic laryngectomy───声门上喉次全切除术

60 、Reporting Services will calculate the subtotal based on the aggregate in the data cell for the group.───Reporting Services将基于组的数据单元中的聚合计算小计。

61 、In most pancreatic gastrinomas only subtotal or total gastrectomy could be useful in this series.───在大多数胰的胃泌素瘤，只有胃次全或全切除有助。

62 、Subtotal bilateral adrenalectomy───双侧肾上腺次全切除术

63 、subtotal resection of maxilla───上颌骨次全切除术

64 、Rat model of chronic renal failure induced by subtotal nephrectomy.───大鼠肾大部切除诱发慢性肾衰模型的建立。

65 、Conclusion Subtotal laryngectomy with preservation of arytenoid cartilage is recommended for T3 laryngeal cancer.───手术的关键是不能损伤杓状软骨及喉返神经，设计好环咽吻合方案。

66 、The SUBTOTAL function can control whether or not hidden rows are included in the results and always ignores rows that have been filtered.───SUBTOTAL函数可以控制是否在结果中包括隐藏的行,并始终忽略已过滤的行。

67 、reformative subtotal thyroidectomy───改良的甲状腺次全切除术

68 、Method Forty-eight patients with cardia cancer complicated with portal hypertension underwent the esophagectomy,proximal subtotal gastrectomy or total gastrectomy and lienectomy.───方法48例贲门癌合并门静脉高压症患者施行食管、上半胃(或)全胃切除、脾切除,特别强调行贲门癌根术基础上结扎、切断异常侧支循环。

69 、Subtotal multi vertebrectomy───多椎体次全切除

70 、Methods:Clinical data of 215 patients with subtotal gastrectomy from 1994 to 2005 were retrospectively analysed.───方法:对1994年至2005年收治的215例胃大部切除术患者的临床资料进行回顾性分析。

71 、combined subtotal resection of hemicranial base───半侧颅底次全联合切除术

72 、Subtotal hypophysectomy by transfrontal approach───垂体次全切除术经额进路

73 、Effect of parietal cell vagotomy and subtotal gastrectomy on digestive function───壁细胞迷走神经切断术与胃大部切除术后对消化功能的影响

74 、A method of effect determination for acupuncture anesthesia in subtotal gastrectomy was also introduced.───作者还介绍了评定针麻胃大部切除手术效果的方法。

75 、CUBE adds subtotal rows into the result sets of queries with GROUP BY clauses, providing all possible combinations of the variables specified in the query.───CUBE将子汇总行添加到使用GROUP BY子句查询的结果集中,提供查询中指定变量的所有可能组合。

76 、Subtotal hysterectomy after Cesarean section───剖腹产合并次全子宫切除术

77 、Business professionals can also view groups of business data, subtotal data, and drill down into the data using the new PivotDiagram template.───商务专业人员还可以使用新数据透视关系图模板查看业务数据组、分类汇总数据以及查看数据的详细信息。

78 、Methods The clinical data of 18 patients with gastroparesis after subtotal gastrectomy were retrospectively analyzed.───方法对行胃大部切除术后发生胃瘫的18例病人的治疗过程和效果进行回顾性分析。

79 、Methods Between 1990 and 2005,172 cases of uge goiter were subjected to subtotal or total thyroidectomy in our hospital.───方法对172例巨大甲状腺肿行双侧甲状腺大部分切除或甲状腺全切除术。

80 、In 25 placental abruption cases,5 fetal death(20%),2 neonatal death(8%),l stillbirth(4%), 5 neonatal asphyxia(20%),l maternal death (4%), 5 subtotal hysterectomy(20%) ,9 postpartum hemorrhage.───25例**早剥患者中死胎5例(20%),新生儿死亡2例(8%),死产1例(4%),新生儿窒息5例(20%),孕产妇死亡1例(4%),次全子宫切除5例(20%),产后出血9例(36%)。

81 、Lobectomy of the right thyroid and subtotal lobectomy of the left thyroid───右侧甲状腺腺叶切除加左侧甲状腺部分切除术

SUBTOTAL函数如何使用

SUBTOTAL函数本身只支持SUM、AVERAGE、MAX、MIN、COUNT等统计功能，而不支持SUMIF、SUMIFS等条件求和的功能。但是，我们可以通过将条件求和函数（如SUMIF、SUMIFS）嵌套到SUBTOTAL函数中来实现这个功能。

具体操作方法如下：

首先，我们需要将SUBTOTAL函数的第一个参数设为一个条件，以便对指定区域的数据进行过滤。比如，我们可以使用3表示“只对可见单元格进行计算”。

然后，在第二个参数中，我们可以将SUMIF或SUMIFS函数嵌套进去，以实现条件求和的功能。在嵌套函数中，需要使用OFFSET或INDEX等函数来获取可见单元格的区域，然后再将其作为条件传递给SUMIF或SUMIFS函数。

下面是一个示例公式，用于计算A列中所有状态为“已审核”的金额之和：

=SUBTOTAL(9,OFFSET(A1,1,0,COUNTA(A:A)-1,1))*SUMIF(B:B,"已审核",C:C)

其中，第一个参数9表示SUM功能，并且只计算可见单元格；OFFSET函数用于获取可见单元格的区域（从A2开始，到A列最后一个非空单元格）；SUMIF函数用于根据状态“已审核”来筛选对应的金额，并进行求和。

需要注意的是，这种方法在数据量较大时可能会导致计算速度变慢，因此建议只在必要时使用。

SUM与SUBTOTAL函数有什么区别呢

一、两者用法不同

SUBTOTAL，日常中最常见到的是在分类汇总中， 返回列表或数据库中的分类汇总。通常使用数据菜单中的分类汇总命令可以容易地创建带有分类汇总的列表。一旦创建了分类汇总，就可以通过编辑 SUBTOTAL 函数对该列表进行修改。

SUM函数指的是返回某一单元格区域中数字、逻辑值及数字的文本表达式之和。如果参数中有错误值或为不能转换成数字的文本，将会导致错误。SUM函数是一个数学和三角函数，可将值相加。 可以将单个值、单元格引用或是区域相加，或者将三者的组合相加。

二、功能特性不同

当 function_num 为从101到111 的常数时，SUBTOTAL 函数将忽略通过格式菜单的行子菜单下面的隐藏命令所隐藏的行中的值，当只分类汇总列表中的非隐藏数字时，使用这些常数。但不论使用什么 function_num 值，SUBTOTAL 函数都会忽略任何不包括在筛选结果中的行。 

SUM函数要相加的第一个参数可以是数字，或Excel中A1 之类的单元格引用或 A2:A8 之类的单元格范围。如果参数为数组或引用，只有其中的数字将被计算。数组或引用中的空白单元格、逻辑值、文本将被忽略。

扩展资料：

SUM的用法说明：

SUM将指定为参数的所有数字相加，每个参数都可以是区域、单元格引用、数组、常量、公式 或另一个函数的结果。例如，SUM(A1:A5)将单元格A1 至 A5 中的所有数字相加，再如，SUM(A1, A3, A5)将单元格 A1、A3 和 A5 中的数字相加。

如果A是一个向量，sum(A)返回这个向量中所有元素的和。如果A是一个矩阵，sum(A)把A的各列看做一个向量，并返回一个行向量，这个行向量的第n个元素是A中第n列元素的和。如果A是一个多维数组，sum(A)仅仅计算A中第一个非奇异维，并把它看成一个向量，计算后返回一个行向量组。

百度百科-subtotal

百度百科-sum