ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Report Help from Bagram (https://www.excelbanter.com/excel-worksheet-functions/118490-report-help-bagram.html)

dan

Report Help from Bagram
 
I would like assistance with an accumulator formula in an Excell spreadsheet
report I have.

Basically the cells have number in them besides one so the accumulator
won't work
any idea how to work this scenario:

A1[2345] B1[3456] C1 = the changing data cell that updates the other
two


MY CURRENT BASIC FORMULA A1 = A1+C1

Any help is great...

thanks

V/r MSGT ANDERS
BAF, Afghanistan


Niek Otten

Report Help from Bagram
 
Maybe this is of help to you:

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Dan" wrote in message ...
|I would like assistance with an accumulator formula in an Excell spreadsheet
| report I have.
|
| Basically the cells have number in them besides one so the accumulator
| won't work
| any idea how to work this scenario:
|
| A1[2345] B1[3456] C1 = the changing data cell that updates the other
| two
|
|
| MY CURRENT BASIC FORMULA A1 = A1+C1
|
| Any help is great...
|
| thanks
|
| V/r MSGT ANDERS
| BAF, Afghanistan
|




All times are GMT +1. The time now is 07:09 PM.

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