Sums of varying number of cells. Sums of parts of a column depending on content

if the data is sorted as outlined (by ID) then:

C2: =IF($A2=$A3;"";SUM($B$2:$B2)-SUM($C$1:$C1))

where first ID value appears in row 2, and row 1 is header / blank

in essence the above will calculate a total for last entry of a given ID, and the total will be equal to the net of Column B to that point (for all IDs) less the sum of any previously calculated residual totals, {the difference must be the residual of the current ID}.

It would help if you attached a sample Excel workbook, then we can set up the formula in the correct column and post the solution back to you where it will be translated into Swedish for you.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete