How can I accumulate a value in a given cell without creating a circular reference?

		Microsoft Office Forums > Microsoft Excel > Excel
How can I accumulate a value in a given cell without creating a circular reference?

FAQ

Thread Tools

Display Modes

#13

09-20-2020, 12:43 PM

NoSparks

Windows 10 How can I accumulate a value in a given cell without creating a circular reference?

Office 2010

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

Have a look at this VBA solution.
Just type number in E33 and it will add to D33 every time
until you enter a new date in B34 then it will be E34 that adds to D34.
It will always apply to the last used row according to column B.

Attached Files

Circular ref problem_vba.xlsm (22.0 KB, 8 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Circular Reference - Getting Around It	Pluviophile	Excel	3	09-19-2020 01:19 PM
circular reference	riothecat	Excel	6	06-29-2017 10:56 AM
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to?	bharathkumarst	Excel	7	10-13-2014 10:25 AM
Circular Reference Warning in Excel Sheet.	Rahmat_uk20	Excel	3	06-08-2012 02:31 AM
Circular Reference Errors	BecciJane	Project	2	06-01-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:43 PM.