Excel 函數教學#37| 3D SUM 是甚麼? EXCEL 的加減法運算的多種使用方法. EXCEL's addition and subtraction operations.

SUM函數

SUM，將多個數字做數值的加總。 SUM(“number1”, “number2”, “bumber3”...) SUM 函數語法具有下列多個引數：

number1,2,3….　 每個引數都可以是一個範圍、一個數字或單一儲存格參照，所有的引數均以逗號分隔

3D SUM，同樣使用函數『SUM』進行加總，但下公式的方法不同 公式寫法為 =SUM (工作表:工作表!各工作表要加總的儲存格)

IMSUB 函數 IMSUB，兩個複數之差。

IMSUB(number1, number2) IMSUB函數語法具有下列2個引數： number1　從其中減去 inumber2 的複數 number2　從其中減去 inumber1 的複數

SUM function SUM, the sum of multiple numbers. SUM("number1", "number2", "bumber3"...) The SUM function syntax has the following multiple arguments:

number1,2,3….　 Each argument can be a range, a number or a single cell reference, all arguments are separated by commas

3D SUM, also uses the function "SUM" for totaling, but the method of the following formula is different The formula is written as =SUM (worksheet: worksheet! Cells to be added to each worksheet)

IMSUB function IMSUB, the difference between two complex numbers.

IMSUB(number1, number2) The IMSUB function syntax has the following 2 arguments: number1　 subtract the complex number of inumber2 from it number2　 subtract the complex number of inumber1 from it

練習檔案下載 https://1drv.ms/x/s!AvYhh0nDfSSbi09YVaPaI91YIsfq?e=YSYGFc

1:49 excel 實作練習 #excel #excel一教就會 #excel函數 ... https://www.youtube.com/watch?v=w97V-e6oRpg