也许有人知道如何做到这一点。 我有6栏(A-F)。 头三栏是一栏,最后三栏是另一栏。 我想总结两套,然后发现数额之间的差别。 例如,如果增长是:
A1 A2 A3 A4 A5 A6
4 5 6 7 8 9
我想增加4+5+6和7+8+9,然后发现这两个数额之间的差别。
我想到的是:=SUM(A1:A3)-SUM(A4:A6)。
如果你只关心这一规模,你可以将其放在绝对值上:=ABS(SUM(A1:A3)-SUM(A4:A6)。
[适合订正员额]
而且,既然我更仔细地阅读了你的职位,你也想在一栏内增加项目。 在此情况下,除你改动外,其公式相同:
本着先前的回答的精神,它提出了意见。
=SUM($A$1:$A$3)-SUM($A$4:$A$6)
另一种解决办法是:
=$A$1+$A$2+$A$3-$A$4-$A$5-$A$6
这笔钱是不必要的,但如果你利用 mo子来建立这一公式,你就会拿到这些钱,而不要这样做。
您可按顺序排列,并使用<代码>=SUM()。 阁下还提到,A-F有6栏,A-C和D-F有2组,因此应该如此:
=SUM(A1:C1)-SUM(D1:F1)
或
=SUM(A1, B1, C1)-SUM(D1, E1, F1)
For an Excel formula I need the first cell out of a list of cells which contains a numeric value: A | B | C | ... | Z | ----------------------------- | 0.1 | 0.4 | ... | =0.1 | | ...
I have a stored procedure that imports differently formatted workbooks into a database table, does work on them then drops the table. Here is the populating query. SELECT IDENTITY(INT,1,1) AS ID ...
The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...
I m using Application run to call several macros in order like this. Sub Run_All_Macros() Application.Run ("Macro_1") Application.Run ("Macro_1") End Sub When I start Run_All_Macros, all the ...
Does anyone know how to convert an Excel date to a correct Unix timestamp?
I am trying to import an excel file into a data table using GemBox and I keep getting this error: Invalid data value when extracting to DataTable at SourceRowIndex: 1, and SourceColumnIndex: 1. As ...
I am looking for any tips or resources on importing from excel into a SQL database, but specifically when the information is NOT in column and row format. I am currently doing some pre-development ...
I have created an Add-In in C# that implements user defined functions for Excel. These UDF s return immediately, but they control background asynchronous procedures. These procedures have status ...