Sum in a matrix

[wtsabo]

Hi I am having trouble solving this problem.

I have a matrix of an amortization schedule and need to sum the scheduled payments per period.

	Disbursements	1	2	3	4	5	6
1/31/2023	33,570,352	(4,997,900)	(5,222,805)	(5,457,832)	(5,703,434)	(5,960,089)	(6,228,293)
2/28/2023	36,321,284	(5,407,454)	(5,650,790)	(5,905,075)	(6,170,803)	(6,448,490)	(6,738,672)
3/31/2023	44,181,605	(6,577,686)	(6,873,682)	(7,182,998)	(7,506,233)	(7,844,013)	(8,196,994)
4/30/2023	37,867,905	(5,637,713)	(5,891,410)	(6,156,523)	(6,433,567)	(6,723,077)	(7,025,616)
5/31/2023	37,882,479	(5,639,882)	(5,893,677)	(6,158,893)	(6,436,043)	(6,725,665)	(7,028,320)
6/30/2023	39,028,621	(5,810,518)	(6,071,991)	(6,345,231)	(6,630,766)	(6,929,151)	(7,240,963)

For example, the repayments in April 2023 will be C3 + D2 + E1.

Is there a formulaic way to do this instead of a manual approach.

 

[KRice]

It is likely that a formula-based approach can be used, but two things would facilitate a solution:

• What version of Excel are you using? (update account details to show this)
• Regarding the table shown above, where is it located on your worksheet? I can't tell what values are supposed to be associated with April 2023 or where C3, D2, and E1 are located. I would guess that C3=-5,407,454, D2=-5,222,805, E1=3...but I doubt that is correct...and those values appear on rows whose 1st column is 2/28/2023, 1/31/2023, and blank, respectively (which seems to be unrelated to April 2023.