?subtotal

subtotal發(fā)音

英：['s?bt??tl]　　美：[s?b?totl]

英：　　美：

subtotal中文意思翻譯

adj.不完全的

v.小計達到

n.小計

subtotal詞形變化

動詞第三人稱單數(shù): subtotals/subtotals | 動詞過去式: subtotaled/subtotalled | 動詞過去分詞: subtotaled/subtotalled | 動詞現(xiàn)在分詞: subtotaling/subtotalling |

subtotal常見例句

1 、Gangner M. Endoscopic subtotal parathyroidectomy in patients with primary hyperparathyroidism[J]. Br Surg 1996,83(7):875.───仇明，丁爾迅，江道振等.頸部無瘢痕內(nèi)鏡甲狀腺腺瘤切除術(shù)一例[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例胃大部切除術(shù)后發(fā)生的12例FDGE患者的臨床特點及診治經(jīng)過。

3 、Methods:Retrospectively analyse the clinical data of 120 cases of laparoscopic subtotal choleeystectomy in complicated cases.───方法:回顧分析了120例復(fù)雜情況下行腹腔鏡膽囊次全切除的臨床資料及治療效果。

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.───因早發(fā)腰椎間盤突出需再次手術(shù)病人的臨床療效比得上那些接受了不復(fù)雜腰椎間盤次全切除術(shù)的病人。

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.───例如,假如有一個“已訂購產(chǎn)品”報表,該報表顯示數(shù)據(jù)庫中每類產(chǎn)品的已訂購數(shù)量的分類匯總。

6 、After subtotal thyroidectomy, he still had diplopia in a certain gaze.───在接受次甲狀腺全切除手術(shù)之后，復(fù)視的情形仍然存在。

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染色體具有形態(tài)上相同的、異染色質(zhì)幾乎全部缺失的男性和55名Y染色體正常的男性 進行了80項形態(tài)生理學(xué)性狀的研究。

8 、Those with unfavorable features were randomized to four or six cycles of chemotherapy plus involved field radiotherapy or subtotal nodal radiotherapy.───情況較差的患者被隨機進行四療程或六療程化療加相關(guān)區(qū)域放療，或全淋巴結(jié)放療。

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例胃大部切除術(shù)后功能性殘胃無力癥的臨床表現(xiàn)、診斷與治療方法與結(jié)果回顧。

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.───方法 :討論目前治療胰腺癌的各種手術(shù)方法 ,包括Whipple手術(shù)、保留幽門的胰十二指腸切除術(shù)、胰腺次全和全切術(shù)、區(qū)域性胰腺切除術(shù)以及廣泛的淋巴結(jié)清掃等。

11 、Creates a field called FreightPercentage, and then displays the percentage of freight charges in each subtotal.───創(chuàng)建一個稱為“運費百分比”的字段,然后顯示每個分類匯總中的運費所占的百分比。

12 、Subtotal perineal prostatectomy───會陰前列腺次全切除術(shù)

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例僅行甲狀腺腺瘤摘除術(shù),后期51例根據(jù)術(shù)中探查結(jié)果30例行甲狀腺次全切除,21例行腺葉切除術(shù)。

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%.───手術(shù)方式以胃大部切除為主(80.5%),術(shù)后5年生存率為86.4%,復(fù)發(fā)率為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.───摘要 摘要：目的 研究胃大部分切除術(shù)后胃癌患者血清胃泌素(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───心包次全切除術(shù)伴心肺分流術(shù)

18 、Methods:The clinical materials were retrospectively analysed in 11 cases of gastroparesis after radical subtotal gastrectomy.───方法:回顧性分析11例根治性遠端胃大部切除術(shù)后胃癱的臨床資料。

19 、The major indicatio of subtotal hysterectomy were postpartum hemorrhage, uterine inertia and placental related factors.───產(chǎn)后出血、宮縮乏力和**因素是子宮次全切術(shù)的主要手術(shù)指征。

20 、Like ROLLUP and CUBE, this operation adds subtotal rows into the result sets of queries with GROUP BY clauses.───與ROLLUP和CUBE一樣,此操作將子匯總行添加到使用GROUP BY子句的查詢結(jié)果集中。

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.───假設(shè)您需要添加一些文本以對小計進行注釋,而且與此同時,讓小計與單個定單量出現(xiàn)在同一列中。

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例遠端胃大部切除術(shù)后胃癱進行臨床分析。

24 、subtotal supracervical hysterectomy───子宮次全切除術(shù)

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年最后的論文中，他把原來的斜角肌切除術(shù)改變?yōu)榇稳苯羌∏星谐⒃?到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年中使用保留甲狀腺下動脈術(shù)式,盡可能多的保留正常甲狀腺組織治療68例雙側(cè)結(jié)節(jié)性甲狀腺腫與同期使用傳統(tǒng)方法治療結(jié)節(jié)性甲狀腺腫進行比較分析。

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子句的查詢結(jié)果集中。

29 、Keywords subtotal thyroidectomy;ante carvix muscle group;───關(guān)鍵詞甲狀腺大部切除術(shù);頸前肌群;

30 、Subtotal hysterectomy after cesarean delivery───剖宮產(chǎn)后次全子宮切除術(shù)

31 、METHODS The study 192 hyperthyroidism cases after subtotal thyroidectomy to observe the postoperative complications.───方法對192例甲狀腺機能亢進癥病人進行甲狀腺次全切除術(shù),對術(shù)后并發(fā)癥進行觀察。

32 、Methods 5 patients after subtotal gastrectomy and enteron reconstructed by colon were analyzed retrospectively,and several reconstructive methods were also analyzed.───方法回顧性分析5例胃大部切除術(shù)后食管癌經(jīng)結(jié)腸代食管重建消化道治療的臨床病例資料,比較分析幾種消化道重建術(shù)式的優(yōu)缺點。

33 、The COTs had a total removal in 44 cases ((78.6%)) and subtotal removal in 12 ((21.4%)).───44例腫瘤(78.6%)獲手術(shù)全切除,12例(21.4%)為次全切除。

34 、Two months later, a second subtotal cytoreductive surgery was performed and anaplastic intramedullary astrocytoma was proved by pathology results.───再經(jīng)過詳細檢查及評估之后，第二次手術(shù)才進行腫瘤切除，組織病理報告證實為脊髓內(nèi)惡性星狀細胞瘤。

35 、Patients with favorable features were randomized to subtotal nodal radiotherapy or three cycles of chemotherapy plus involved-field radiotherapy.───情況較好的患者被隨機進行全淋巴結(jié)放療，或三療程化療加相關(guān)區(qū)域放療。

36 、In the caesarian section group, conservative operations were performed in six patients, and subtotal hysterectomy in two.───8例剖宮產(chǎn)手術(shù)病人 6例行保守性手術(shù)治療 ,2例行次全子宮切除術(shù) ;

37 、In 14 dogs, renal artery stenosis wag produced by unilateral subtotal ligation. chromic catgut. Renovasoular hypertension developed in 12 of them.───對14條犬用手術(shù)方式結(jié)扎單側(cè)腎動脈,12條犬產(chǎn)生高血壓。

38 、All patients underwent resections of epidermoid cyst, 1 total resection,and 9 subtotal resections.───10例患者均行手術(shù)治療，腫瘤全切除1例，次全切除9例。

39 、Wedge resection of venter and Subtotal hysterectomy clinic contrast analysis───子宮體楔形切除術(shù)與子宮次全切除術(shù)的臨床對比分析

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年以上間歇性腹痛及便秘癥狀的年輕女性在本院接受手術(shù)治療。

41 、One stage subtotal suprapubic prostatectomy───一期恥骨上前列腺次全切除術(shù)

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).───摘要目的：比較腹腔鏡輔助子宮次全切除術(shù)與傳統(tǒng)剖腹子宮次全切除術(shù)的療效。

44 、Congenital subtotal cataract───先天性次全內(nèi)障

45 、Twenty-nine historical control patients who had undergone uncomplicated subtotal lumbar discectomy were selected.───29例接受不復(fù)雜腰椎間盤次全切除術(shù)的病人被選作為病例對照。

46 、Analysis of 25 patients with subtotal hysterectomy in cesarean section───剖宮產(chǎn)子宮次全切術(shù)25例分析

47 、We report a 24-year-old female with thyroid tumor who was admitted for subtotal thyroidectomy.───我們在此報告一位24歲患有甲狀腺腫瘤女**人，入院接受次全甲狀腺切除手術(shù)。

48 、Low vision(the older term subnormal vision has been abandoned) refers to a reduction is central acuity or a subtotal visual field loss.───低視力(多發(fā)于老年期的視力減退)表現(xiàn)為中心視力下降或局限性視野的缺損。

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例良性腫瘤,行保留胰腺的十二指腸全切除術(shù)3例,乳頭以下的十二指腸切除術(shù)1例。

50 、The ear cancer was treated by subtotal temporal bone resection.───中、外耳癌則實行顳骨次全切除術(shù)。

51 、After emergent management such as: intrauterine gauze packing dilatation and cuettage were failed, a subtotal hysterectomy was required to save the patient.───我們建議剖腹產(chǎn)時在有感染因素高之孕婦如難產(chǎn)者可行預(yù)防性抗生素，可以避免此少見之大出血。

52 、Inserts a subtotal for a row field or column field in an existing pivot table.───在當(dāng)前數(shù)據(jù)透視表中**入列字段或行字段的分類匯總。

53 、For each purchase order an XQuery is executed that returns a formatted result of each product subtotal.───對于每個采購訂單,都將執(zhí)行一個XQuery,返回每個產(chǎn)品小計的格式化結(jié)果。

54 、Count cells in a list or Excel table column by using the SUBTOTAL function───使用SUBTOTAL函數(shù)對列表或Excel表列中的單元格進行計數(shù)

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例恢復(fù)正常生活。結(jié)論:顱底脊索瘤發(fā)病率低,手術(shù)全切除的難度大,需結(jié)合放射治療。本病預(yù)后差。

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鎖定型頸椎前路鋼板固定術(shù)。

58 、The sum of the values of the Subtotal and Freight fields or controls.───“分類匯總”和“運費”字段或控件的值之和。

59 、subtotal supraglottic laryngectomy───聲門上喉次全切除術(shù)

60 、Reporting Services will calculate the subtotal based on the aggregate in the data cell for the group.───Reporting Services將基于組的數(shù)據(jù)單元中的聚合計算小計。

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

62 、Subtotal bilateral adrenalectomy───雙側(cè)腎上腺次全切除術(shù)

63 、subtotal resection of maxilla───上頜骨次全切除術(shù)

64 、Rat model of chronic renal failure induced by subtotal nephrectomy.───大鼠腎大部切除誘發(fā)慢性腎衰模型的建立。

65 、Conclusion Subtotal laryngectomy with preservation of arytenoid cartilage is recommended for T3 laryngeal cancer.───手術(shù)的關(guān)鍵是不能損傷杓狀軟骨及喉返神經(jīng)，設(shè)計好環(huán)咽吻合方案。

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函數(shù)可以控制是否在結(jié)果中包括隱藏的行,并始終忽略已過濾的行。

67 、reformative subtotal thyroidectomy───改良的甲狀腺次全切除術(shù)

68 、Method Forty-eight patients with cardia cancer complicated with portal hypertension underwent the esophagectomy,proximal subtotal gastrectomy or total gastrectomy and lienectomy.───方法48例賁門癌合并門靜脈高壓癥患者施行食管、上半胃(或)全胃切除、脾切除,特別強調(diào)行賁門癌根術(shù)基礎(chǔ)上結(jié)扎、切斷異常側(cè)支循環(huán)。

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

70 、Methods:Clinical data of 215 patients with subtotal gastrectomy from 1994 to 2005 were retrospectively analysed.───方法:對1994年至2005年收治的215例胃大部切除術(shù)患者的臨床資料進行回顧性分析。

71 、combined subtotal resection of hemicranial base───半側(cè)顱底次全聯(lián)合切除術(shù)

72 、Subtotal hypophysectomy by transfrontal approach───垂體次全切除術(shù)經(jīng)額進路

73 、Effect of parietal cell vagotomy and subtotal gastrectomy on digestive function───壁細胞迷走神經(jīng)切斷術(shù)與胃大部切除術(shù)后對消化功能的影響

74 、A method of effect determination for acupuncture anesthesia in subtotal gastrectomy was also introduced.───作者還介紹了評定針麻胃大部切除手術(shù)效果的方法。

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子句查詢的結(jié)果集中,提供查詢中指定變量的所有可能組合。

76 、Subtotal hysterectomy after Cesarean section───剖腹產(chǎn)合并次全子宮切除術(shù)

77 、Business professionals can also view groups of business data, subtotal data, and drill down into the data using the new PivotDiagram template.───商務(wù)專業(yè)人員還可以使用新數(shù)據(jù)透視關(guān)系圖模板查看業(yè)務(wù)數(shù)據(jù)組、分類匯總數(shù)據(jù)以及查看數(shù)據(jù)的詳細信息。

78 、Methods The clinical data of 18 patients with gastroparesis after subtotal gastrectomy were retrospectively analyzed.───方法對行胃大部切除術(shù)后發(fā)生胃癱的18例病人的治療過程和效果進行回顧性分析。

79 、Methods Between 1990 and 2005,172 cases of uge goiter were subjected to subtotal or total thyroidectomy in our hospital.───方法對172例巨大甲狀腺腫行雙側(cè)甲狀腺大部分切除或甲狀腺全切除術(shù)。

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%),死產(chǎn)1例(4%),新生兒窒息5例(20%),孕產(chǎn)婦死亡1例(4%),次全子宮切除5例(20%),產(chǎn)后出血9例(36%)。

81 、Lobectomy of the right thyroid and subtotal lobectomy of the left thyroid───右側(cè)甲狀腺腺葉切除加左側(cè)甲狀腺部分切除術(shù)

SUBTOTAL函數(shù)如何使用

SUBTOTAL函數(shù)本身只支持SUM、AVERAGE、MAX、MIN、COUNT等統(tǒng)計功能，而不支持SUMIF、SUMIFS等條件求和的功能。但是，我們可以通過將條件求和函數(shù)（如SUMIF、SUMIFS）嵌套到SUBTOTAL函數(shù)中來實現(xiàn)這個功能。

具體操作方法如下：

首先，我們需要將SUBTOTAL函數(shù)的第一個參數(shù)設(shè)為一個條件，以便對指定區(qū)域的數(shù)據(jù)進行過濾。比如，我們可以使用3表示“只對可見單元格進行計算”。

然后，在第二個參數(shù)中，我們可以將SUMIF或SUMIFS函數(shù)嵌套進去，以實現(xiàn)條件求和的功能。在嵌套函數(shù)中，需要使用OFFSET或INDEX等函數(shù)來獲取可見單元格的區(qū)域，然后再將其作為條件傳遞給SUMIF或SUMIFS函數(shù)。

下面是一個示例公式，用于計算A列中所有狀態(tài)為“已審核”的金額之和：

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

其中，第一個參數(shù)9表示SUM功能，并且只計算可見單元格；OFFSET函數(shù)用于獲取可見單元格的區(qū)域（從A2開始，到A列最后一個非空單元格）；SUMIF函數(shù)用于根據(jù)狀態(tài)“已審核”來篩選對應(yīng)的金額，并進行求和。

需要注意的是，這種方法在數(shù)據(jù)量較大時可能會導(dǎo)致計算速度變慢，因此建議只在必要時使用。

SUM與SUBTOTAL函數(shù)有什么區(qū)別呢

一、兩者用法不同

SUBTOTAL，日常中最常見到的是在分類匯總中， 返回列表或數(shù)據(jù)庫中的分類匯總。通常使用數(shù)據(jù)菜單中的分類匯總命令可以容易地創(chuàng)建帶有分類匯總的列表。一旦創(chuàng)建了分類匯總，就可以通過編輯 SUBTOTAL 函數(shù)對該列表進行修改。

SUM函數(shù)指的是返回某一單元格區(qū)域中數(shù)字、邏輯值及數(shù)字的文本表達式之和。如果參數(shù)中有錯誤值或為不能轉(zhuǎn)換成數(shù)字的文本，將會導(dǎo)致錯誤。SUM函數(shù)是一個數(shù)學(xué)和三角函數(shù)，可將值相加。 可以將單個值、單元格引用或是區(qū)域相加，或者將三者的組合相加。

二、功能特性不同

當(dāng) function_num 為從101到111 的常數(shù)時，SUBTOTAL 函數(shù)將忽略通過格式菜單的行子菜單下面的隱藏命令所隱藏的行中的值，當(dāng)只分類匯總列表中的非隱藏數(shù)字時，使用這些常數(shù)。但不論使用什么 function_num 值，SUBTOTAL 函數(shù)都會忽略任何不包括在篩選結(jié)果中的行。 

SUM函數(shù)要相加的第一個參數(shù)可以是數(shù)字，或Excel中A1 之類的單元格引用或 A2:A8 之類的單元格范圍。如果參數(shù)為數(shù)組或引用，只有其中的數(shù)字將被計算。數(shù)組或引用中的空白單元格、邏輯值、文本將被忽略。

擴展資料：

SUM的用法說明：

SUM將指定為參數(shù)的所有數(shù)字相加，每個參數(shù)都可以是區(qū)域、單元格引用、數(shù)組、常量、公式 或另一個函數(shù)的結(jié)果。例如，SUM(A1:A5)將單元格A1 至 A5 中的所有數(shù)字相加，再如，SUM(A1, A3, A5)將單元格 A1、A3 和 A5 中的數(shù)字相加。

如果A是一個向量，sum(A)返回這個向量中所有元素的和。如果A是一個矩陣，sum(A)把A的各列看做一個向量，并返回一個行向量，這個行向量的第n個元素是A中第n列元素的和。如果A是一個多維數(shù)組，sum(A)僅僅計算A中第一個非奇異維，并把它看成一個向量，計算后返回一個行向量組。

百度百科-subtotal

百度百科-sum