Need to create the loop calculation having multi dependencies on each other.

[Dhairya]

Hi team, 

seeking your help to calculate the loop in below mention table in which Quater, column B, column C & first row of column [A] is given data, I need to calculate column D which is [Total]-[C], [Total] is [A]+[B] and another row of column [A] excluding first row. but problem is [A] second row data depends on previous row of column [D] which again depends on [Total] & column [A]. below please find the table for easy understanding the requirement.

Quarter	A	B	Total	C	D
Mar - 2022	709,747,944.59		[A]+[B]	30,078.72	Total- [C]
Apr - 2022	Mar [D]	1,956,530.77	[A]+[B]	502,094.25	Total- [C]
May - 2022	Apr [D]	2,910,488.19	[A]+[B]	14,921,258.22	Total- [C]
Jun - 2022	May [D]		[A]+[B]	24,370,303.62	Total- [C]
Jul - 2022	Jun [D]		[A]+[B]	28,008,419.02	Total- [C]
Aug - 2022	Jul [D]		[A]+[B]	27,459,069.48	Total- [C]

[martinding]

Hi @Dhairya ,

So are the empty cells in column B all 0s?

If so, you could try the approach below:

[Dhairya]

Hi Martinding,

many thanks for the solution, empty column [B] may 0r may not  be 0, it will get updated every month.

[martinding]

Hi @Dhairya,

Cool, as long as Column B contains a value then this same solution would work.