Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Calculating a sum with running total and replacement

Does anyone know how to add e.g B2 to C2 = D2 with the result of D2 replacing
B2 after result is shown in D2. B2 (0) + C2 (3) = D2 (3) turns to B2 (3) +
C2 (Blank) = 3 and so on.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,440
Default Calculating a sum with running total and replacement

Excel really wasn't designed to things like that.

But you could take a look he

http://www.mcgimpsey.com/excel/accumulator.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mouse" wrote in message ...
| Does anyone know how to add e.g B2 to C2 = D2 with the result of D2 replacing
| B2 after result is shown in D2. B2 (0) + C2 (3) = D2 (3) turns to B2 (3) +
| C2 (Blank) = 3 and so on.


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Calculating a sum with running total and replacement

Bugger I am trying to use an excel sheet to replace our Point of Sale when
our Wireless Network goes down as we are continually having problems, and a
few of the workers have trouble understanding computers. I was trying to
make it fool proof. Thanks anyway.

"Niek Otten" wrote:

Excel really wasn't designed to things like that.

But you could take a look he

http://www.mcgimpsey.com/excel/accumulator.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mouse" wrote in message ...
| Does anyone know how to add e.g B2 to C2 = D2 with the result of D2 replacing
| B2 after result is shown in D2. B2 (0) + C2 (3) = D2 (3) turns to B2 (3) +
| C2 (Blank) = 3 and so on.



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Calculating a sum with running total and replacement

Hey you are amazing this actually works.

"Niek Otten" wrote:

Excel really wasn't designed to things like that.

But you could take a look he

http://www.mcgimpsey.com/excel/accumulator.html


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Mouse" wrote in message ...
| Does anyone know how to add e.g B2 to C2 = D2 with the result of D2 replacing
| B2 after result is shown in D2. B2 (0) + C2 (3) = D2 (3) turns to B2 (3) +
| C2 (Blank) = 3 and so on.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 12:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"