ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   =sum(A:A) add to column (B) and new value repeats w/ new sums (https://www.excelbanter.com/excel-worksheet-functions/133096-%3Dsum-add-column-b-new-value-repeats-w-new-sums.html)

planecents

=sum(A:A) add to column (B) and new value repeats w/ new sums
 
Mike your formula worked for one cell however I need the column to continue
adding the last value and showing the new result in column B
--
planecents

Bob Phillips

=sum(A:A) add to column (B) and new value repeats w/ new sums
 
Stick to the original thread or re-quote the relevant parts of the other.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"planecents" wrote in message
...
Mike your formula worked for one cell however I need the column to
continue
adding the last value and showing the new result in column B
--
planecents




planecents

=sum(A:A) add to column (B) and new value repeats w/ new sums
 
Bob I still don't understand. Please post the formula. Pretend I am Irish,
60, and from Missouri.
Thanks
Bob@planecents
--
planecents


"planecents" wrote:

Mike your formula worked for one cell however I need the column to continue
adding the last value and showing the new result in column B
--
planecents


Bob Phillips

=sum(A:A) add to column (B) and new value repeats w/ new sums
 
I think it is your formula not mine, and it is you who has the details, not
me.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"planecents" wrote in message
...
Bob I still don't understand. Please post the formula. Pretend I am Irish,
60, and from Missouri.
Thanks
Bob@planecents
--
planecents


"planecents" wrote:

Mike your formula worked for one cell however I need the column to
continue
adding the last value and showing the new result in column B
--
planecents






All times are GMT +1. The time now is 06:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com