ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   what is the correct syntax for an allowable circular reference? (https://www.excelbanter.com/excel-discussion-misc-queries/17037-what-correct-syntax-allowable-circular-reference.html)

excell idiot

what is the correct syntax for an allowable circular reference?
 
I am trying to add the values of two cells and return an updated total to one
of the original two cells. Such as a weekly income update.

Jason Morin

See J.E. McGimpsey's website on how to do this:

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

Scroll to the bottom of the page and look for:

"Worksheet Function Accumulator (using Circular
References)"

HTH
Jason
Atlanta, GA

-----Original Message-----
I am trying to add the values of two cells and return an

updated total to one
of the original two cells. Such as a weekly income

update.
.



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

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