问题描述:

I have Excel table like this. How do I sum all the prices starting from the red line like the arrow shows? So when I add something above the red line it keeps summing from the line below?

网友答案:

If the data was an ordinary Excel range, there wouldn't be a problem because as extra rows are inserted the formula would be modified to allow for them. If you want to keep your data as a table, here is possible workaround.

I suggest adding an extra column to label your data, so I have marked the data that you want to sum with an "x".

In the totals row, under Amount, instead of using SUM you use SUMIF just to get the sum of the rows that are labelled with an "x":_

=SUMIF([Label],"x",[Amount])

So if extra rows are added with a blank Label, they won't be included in the sum.

You might already have something like a date that you could use to select the ones you want to sum instead.

Alternatively there is nothing to stop you using an ordinary Excel range like

=SUM(A7:A13)

or see @Jeeped's excellent suggestion below.

相关阅读:
Top