我有一个要求我需要在n行末端有条件格式的一个名为“总计”的选项卡，其中结果应为“成本”列中所有n行的总和，
例如，如下所示，唯一的我确定成本的第一列是J9。其他所有内容，成本的记录数量以及选项卡总数从哪里开始，因为ETL过程可能会插入n个记录。因此，不确定它将在哪里，但是我需要在第n个记录结束的位置及其的净结果属于总和（j9：jn）的位置。
我尝试了偏移和其他类型的东西，但找不到任何解决方案。请帮忙。
I have a requirement where i need to conditional format a tab called 'Totals' at the end of n rows, where the result should be the SUM of all n rows in 'Cost' column
For example, as you can see below, the only thing i am sure of is the first column of the Cost is j9. and everything else like, number of records for Cost and where does the tab Totals start is unclear as the ETL process might insert n records. so unsure, where it is going to be, but i need the Totals tab in exactly at the place where the nth record end and the net result of it should be SUM(J9:Jn) something like this.
I've tried OFFSET and other sorts of stuff, but couldn't find any solution. Please help.
发布评论
评论（1）
如果您事先准备好在适当的单元格中输入 totals ，则下面的公式将计算成本的总和（是列中j 仅在单词 copt 的下方，而词 plotals ）：
If you're prepared, beforehand, to enter the word Totals in the appropriate cell then the formula below will calculate the summation of the costs (being the total of the cells in column J only below the word Cost and above the word Totals):
