Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-17-2020, 10:25 AM
Tone Dialling Tone Dialling is offline How can I accumulate a value in a given cell without creating a circular reference? Windows 10 How can I accumulate a value in a given cell without creating a circular reference? Office 97-2003
Novice
How can I accumulate a value in a given cell without creating a circular reference?
 
Join Date: Sep 2020
Posts: 6
Tone Dialling is on a distinguished road
Default How can I accumulate a value in a given cell without creating a circular reference?


I keep records of daily sunshine split into the four quarters of the year. For any given quarter, I have one Excel cell containing the accumulated hours of sunshine (to 1 d.p.) in that quarter. I update it daily. Whilst it is not tedious to do the addition in my head, what I would like to be able to do is to enter the day’s figure in one cell and have the accumulated hours updated automatically. Thus, suppose the accumulation always happens in cell Q3 and I place a particular day’s value, say 9.2, always in D3, I want Q3 to recalculate via the formula Q3 = Q3 + D3. But Excel won’t have that, as it contains a circular reference. What I suggest is a fairly simple task seems out of my grasp. How can I achieve the result I want?
Reply With Quote
 



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
How can I accumulate a value in a given cell without creating a circular reference? 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
How can I accumulate a value in a given cell without creating a circular reference? 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 11:19 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft