Prev: where is tthe "read only" TOGGLE button ?
Next: how to calculate the difference of values (numbers) in a column?
From: Scoober on 17 Feb 2010 22:22
I am trying to complete a formula that will enable me to do the following.

D4 = C3 + C4
D5 = C4 + C5

So the total in the D columnis the addition of the new C column total.

example:

B C D
10+10 20 20 <--
20+10 30 50 <-- these is a running totals
5+15 20 70 <--
etc

The formula would be placed in the D column and would remain empty if the C
column is empty.


Thanks in advance.

Scoober
From: T. Valko on 17 Feb 2010 22:32
Enter this formula in D3 and copy down as needed:

=IF(C3="","",SUM(C$3:C3))

--
Biff
Microsoft Excel MVP


"Scoober" <Scoober(a)discussions.microsoft.com> wrote in message
news:8338D7A2-453F-49C4-85CB-C3DFF6CBC641(a)microsoft.com...
>I am trying to complete a formula that will enable me to do the following.
>
> D4 = C3 + C4
> D5 = C4 + C5
>
> So the total in the D columnis the addition of the new C column total.
>
> example:
>
> B C D
> 10+10 20 20 <--
> 20+10 30 50 <-- these is a running totals
> 5+15 20 70 <--
> etc
>
> The formula would be placed in the D column and would remain empty if the
> C
> column is empty.
>
>
> Thanks in advance.
>
> Scoober


 | 
Pages: 1
Prev: where is tthe "read only" TOGGLE button ?
Next: how to calculate the difference of values (numbers) in a column?