View Single Post
 
Old 09-17-2020, 10:25 AM
Tone Dialling Tone Dialling is offline Windows 10 Office 97-2003
Novice
 
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