View Single Post
Old June 15th, 2013, 05:02 AM   #625 (permalink)
jonbanjo
Member
 
Join Date: May 2013
Location: UK
Posts: 209
 
Device(s): Samsung Galaxy Ace 2 sim free, Acer Iconia A200
Carrier: Not Provided

Thanks: 13
Thanked 50 Times in 45 Posts
Default

Quote:
Originally Posted by MoodyBlues View Post

Assume there's a spreadsheet with six fields (columns). Let's say columns 3 and 4 are the columns of interest; 3 will have whole numbers entered into it; 4 should automatically keep a running subtotal. In other words:

Code:
Column 3           Column 4
     100                100
      25                125
     250                375
     100                475
I'm going back a few posts but I don't see the reason for sum used in the solutions I've looked at.

Code:
Column 3   Column4
100        =C2
25         =D2+C3
That is unless totalling on more than one column, eg.

Code:
Column 2   Column3  Column4
25         75       100
15         10       125

25         75       =SUM(B2:C2)
15         10       =SUM(B3:C3)+D2
jonbanjo is offline  
Reply With Quote