?subtotal

subtotal發(fā)音

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

英：　　美：

subtotal中文意思翻譯

adj.不完全的

v.小計達到

n.小計

subtotal詞形變化

動(dòng)詞第三人稱(chēng)單數: subtotals/subtotals | 動(dòng)詞過(guò)去式: subtotaled/subtotalled | 動(dòng)詞過(guò)去分詞: subtotaled/subtotalled | 動(dòng)詞現在分詞: subtotaling/subtotalling |

subtotal常見(jiàn)例句

1 、Gangner M. Endoscopic subtotal parathyroidectomy in patients with primary hyperparathyroidism[J]. Br Surg 1996,83(7):875.───仇明，丁爾迅，江道振等.頸部無(wú)瘢痕內鏡甲狀腺腺瘤切除術(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患者的臨床特點(diǎn)及診治經(jīng)過(guò)。

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.───因早發(fā)腰椎間盤(pán)突出需再次手術(shù)病人的臨床療效比得上那些接受了不復雜腰椎間盤(pán)次全切除術(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.───例如,假如有一個(gè)“已訂購產(chǎn)品”報表,該報表顯示數據庫中每類(lèi)產(chǎn)品的已訂購數量的分類(lèi)匯總。

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

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染色體正常的男性 進(jìn)行了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.───情況較差的患者被隨機進(jìn)行四療程或六療程化療加相關(guān)區域放療，或全淋巴結放療。

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ù)后功能性殘胃無(wú)力癥的臨床表現、診斷與治療方法與結果回顧。

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ù)、保留幽門(mén)的胰十二指腸切除術(shù)、胰腺次全和全切術(shù)、區域性胰腺切除術(shù)以及廣泛的淋巴結清掃等。

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

12 、Subtotal perineal prostatectomy───會(huì )陰前列腺次全切除術(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例根據術(shù)中探查結果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ā)率為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)、血漿胃動(dòng)素（MTL)和胃動(dòng)力的變化情況。

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

21 、I long to vomit one of cigarettes, said: carving insects Subtotal, high aims in life.───我長(cháng)長(cháng)的吐了一口煙,說(shuō):雕蟲(chóng)小計,玩物喪志。

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

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ù)后胃癱進(jìn)行臨床分析。

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.───在A(yíng)dson1947年最后的論文中，他把原來(lái)的斜角肌切除術(shù)改變?yōu)榇稳苯羌∏星谐⒃?到20年的隨訪(fǎng)后報道有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年中使用保留甲狀腺下動(dòng)脈術(shù)式,盡可能多的保留正常甲狀腺組織治療68例雙側結節性甲狀腺腫與同期使用傳統方法治療結節性甲狀腺腫進(jìn)行比較分析。

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會(huì )將子匯總行添加到使用GROUP BY子句的查詢(xún)結果集中。

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例甲狀腺機能亢進(jìn)癥病人進(jìn)行甲狀腺次全切除術(shù),對術(shù)后并發(fā)癥進(jìn)行觀(guān)察。

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)結腸代食管重建消化道治療的臨床病例資料,比較分析幾種消化道重建術(shù)式的優(yōu)缺點(diǎn)。

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)過(guò)詳細檢查及評估之后，第二次手術(shù)才進(jìn)行腫瘤切除，組織病理報告證實(shí)為脊髓內惡性星狀細胞瘤。

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

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ù)方式結扎單側腎動(dòng)脈,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───以下查詢(xún)將生成小計報表

43 、Objective: To compare the clinical characteristics of laparoscope assisted subtotal hysterectomy (LASH) and traditional abdominal subtotal hysterectomy (TASH).───摘要目的：比較腹腔鏡輔助子宮次全切除術(shù)與傳統剖腹子宮次全切除術(shù)的療效。

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

45 、Twenty-nine historical control patients who had undergone uncomplicated subtotal lumbar discectomy were selected.───29例接受不復雜腰椎間盤(pán)次全切除術(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ā)于老年期的視力減退)表現為中心視力下降或局限性視野的缺損。

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í)行顳骨次全切除術(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)時(shí)在有感染因素高之孕婦如難產(chǎn)者可行預防性抗生素，可以避免此少見(jiàn)之大出血。

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

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

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

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例獲得隨訪(fǎng),其中4例死亡,10例恢復正常生活。結論:顱底脊索瘤發(fā)病率低,手術(shù)全切除的難度大,需結合放射治療。本病預后差。

56 、I'd resect rather than do a subtotal pancreatectomy.─── 與其切除整個(gè)胰臟 不如切除尾部組織

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.───“分類(lèi)匯總”和“運費”字段或控件的值之和。

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

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───雙側腎上腺次全切除術(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)，設計好環(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函數可以控制是否在結果中包括隱藏的行,并始終忽略已過(guò)濾的行。

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例賁門(mén)癌合并門(mén)靜脈高壓癥患者施行食管、上半胃(或)全胃切除、脾切除,特別強調行賁門(mén)癌根術(shù)基礎上結扎、切斷異常側支循環(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ù)患者的臨床資料進(jìn)行回顧性分析。

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

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

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

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ù)專(zhuān)業(yè)人員還可以使用新數據透視關(guān)系圖模板查看業(yè)務(wù)數據組、分類(lèi)匯總數據以及查看數據的詳細信息。

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

79 、Methods Between 1990 and 2005,172 cases of uge goiter were subjected to subtotal or total thyroidectomy in our hospital.───方法對172例巨大甲狀腺腫行雙側甲狀腺大部分切除或甲狀腺全切除術(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───右側甲狀腺腺葉切除加左側甲狀腺部分切除術(shù)

SUBTOTAL函數如何使用

SUBTOTAL函數本身只支持SUM、AVERAGE、MAX、MIN、COUNT等統計功能，而不支持SUMIF、SUMIFS等條件求和的功能。但是，我們可以通過(guò)將條件求和函數（如SUMIF、SUMIFS）嵌套到SUBTOTAL函數中來(lái)實(shí)現這個(gè)功能。

具體操作方法如下：

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

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

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

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

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

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

SUM與SUBTOTAL函數有什么區別呢

一、兩者用法不同

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

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

二、功能特性不同

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

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

擴展資料：

SUM的用法說(shuō)明：

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

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

百度百科-subtotal

百度百科-sum