Help adding total from rows to columns.

[FirewalkerZ5]

I am trying to add totals from rows to columns based on sum of values added if total equals specific value in separate cell.
I have tried different formulas but it just is not working.
I was trying to come up with a possible solution by adding If Column C + Column D equals Value on row 4, add values in Column E and F for that row.

PPrctice -5 yr budget planning.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1						Year
2					2023	2024	2025	2026	2027	2028	2029	2030	2031
3	$1,500.00	2024	2023	1	$1,500.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
4	$7,500.00	2024	2028	1						$7,500.00	$0.00	$0.00	$0.00	$0.00
5	$1,500.00	2024	2032	1										$1,500.00
6	$7,500.00	2024	2028	1						$7,500.00	$0.00	$0.00	$0.00	$0.00
7	$1,500.00	2024	2032	1										$1,500.00
8	$6,500.00	2024	2026	1				$6,500.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
9	$1,500.00	2025	2023	2	$750.00	$750.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
10	$6,500.00	2024	2024	1		$6,500.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
11	$1,500.00	2028	2023	5	$300.00	$300.00	$300.00	$300.00	$300.00	$0.00	$0.00	$0.00	$0.00	$0.00
12	$4,000.00	2027	2023	4	$1,000.00	$1,000.00	$1,000.00	$1,000.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
13	$4,000.00	2027	2023	4	$1,000.00	$1,000.00	$1,000.00	$1,000.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
14	$225,000.00	2024	2032	1										$225,000.00
15	$35,000.00	2024	2032	1										$35,000.00
16	$500.00	2028	2023	5	$100.00	$100.00	$100.00	$100.00	$100.00	$0.00	$0.00	$0.00	$0.00	$0.00
17	$300.00	2048	2032	25										$12.00
18	$350.00	2028	2023	5	$70.00	$70.00	$70.00	$70.00	$70.00	$0.00	$0.00	$0.00	$0.00	$0.00
19	$4,000.00	2043	2032	20										$200.00
20	$3,500.00	2028	2023	5	$700.00	$700.00	$700.00	$700.00	$700.00	$0.00	$0.00	$0.00	$0.00	$0.00
21	$3,500.00	2031	2026	8				$437.50	$438.00	$438.00	$438.00	$438.00	$438.00	$438.00
22	$500.00	2030	2025	7			$71.43	$71.00	$71.00	$71.00	$71.00	$71.00	$71.00	$3.00
23	$2,400.00	2024	2024	1		$2,400.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
24	$800.00	2033	2023	10	$80.00	$80.00	$80.00	$80.00	$80.00	$80.00	$80.00	$80.00	$80.00	$80.00
25	$1,500.00	2028	2023	5	$300.00	$300.00	$300.00	$300.00	$300.00	$0.00	$0.00	$0.00	$0.00	$0.00
26	$0.00	#VALUE!		#VALUE!
27						$13,200.00	$3,621.43	$10,558.50	$2,059.00	$15,589.00	$589.00	$589.00	$589.00	$263,733.00
28						$ 8,900.00	$ -	$ 6,500.00	$ -	$15,000.00
29						$4,300.00	$3,621.43	$ 4,058.50	$2,059.00	$ 589.00
30
31						Cell should equal E9 +F9;F10,F23
32
Sheet1

Cell Formulas
Range	Formula
F27:N27	F27	=SUM(F3:F26)
F28:J28	F28	=SUMIFS(F3:F26,$D$3:$D$26,1)
F29:J29	F29	=F27-F28

 

[OaklandJim]

I want to assist but the need is not clear. Maybe try again to explain what is needed. Give a couple of examples of the expected result. I expect that this is not a big deal if I understand what is going on.

 

[Peter_SSs]

Is this what you mean? If not, refer to post #2.

23 07 04.xlsm
	C	D	E	F	G	H	I	J	K	L	M	N
1				Year
2			2023	2024	2025	2026	2027	2028	2029	2030	2031	2032
3	2023	1	1500	0	0	0	0	0	0	0	0	0
4	2028	1						7500	0	0	0	0
5	2032	1										1500
6	2028	1						7500	0	0	0	0
7	2032	1										1500
8	2026	1				6500	0	0	0	0	0	0
9	2023	2	750	750	0	0	0	0	0	0	0	0
10	2024	1		6500	0	0	0	0	0	0	0	0
11	2023	5	300	300	300	300	300	0	0	0	0	0
12	2023	4	1000	1000	1000	1000	0	0	0	0	0	0
13	2023	4	1000	1000	1000	1000	0	0	0	0	0	0
14	2032	1										225000
15	2032	1										35000
16	2023	5	100	100	100	100	100	0	0	0	0	0
17	2032	25										12
18	2023	5	70	70	70	70	70	0	0	0	0	0
19	2032	20										200
20	2023	5	700	700	700	700	700	0	0	0	0	0
21	2026	8				437.5	438	438	438	438	438	438
22	2025	7			71.42857143	71	71	71	71	71	71	3
23	2024	1		2400	0	0	0	0	0	0	0	0
24	2023	10	80	80	80	80	80	80	80	80	80	80
25	2023	5	300	300	300	300	300	0	0	0	0	0
32
33				10400	0	14500	7350	15000	0	0	497.43	263800
Rows to Columns

Cell Formulas
Range	Formula
F33:N33	F33	=SUM(FILTER($E3:F25,$C3:$C25+$D3:$D25-1=F2,0))

 

[FirewalkerZ5]

Thank you for the responses.
What I am looking for is, in the example provided, lets look at Column F.
The calculation would sum Column F and if it was the last of the savings required (Column G would have $0.00) it would include the previous amounts in the form.

So, Column F would sum at bottom and include the additional amount for E9.
If this formula were to be in I27 it would include all of Column I and all of Row 11 16, 18, 20 and 25. Grand total would equal $7,939

I hope this makes more sense

 

[Peter_SSs]

I hope this makes more sense

Yes, previously I thought you only wanted rows that ended that year.

Try this

23 07 04.xlsm
	C	D	E	F	G	H	I	J	K	L	M	N
1				Year
2			2023	2024	2025	2026	2027	2028	2029	2030	2031	2032
3	2023	1	1500	0	0	0	0	0	0	0	0	0
4	2028	1						7500	0	0	0	0
5	2032	1										1500
6	2028	1						7500	0	0	0	0
7	2032	1										1500
8	2026	1				6500	0	0	0	0	0	0
9	2023	2	750	750	0	0	0	0	0	0	0	0
10	2024	1		6500	0	0	0	0	0	0	0	0
11	2023	5	300	300	300	300	300	0	0	0	0	0
12	2023	4	1000	1000	1000	1000	0	0	0	0	0	0
13	2023	4	1000	1000	1000	1000	0	0	0	0	0	0
14	2032	1										225000
15	2032	1										35000
16	2023	5	100	100	100	100	100	0	0	0	0	0
17	2032	25										12
18	2023	5	70	70	70	70	70	0	0	0	0	0
19	2032	20										200
20	2023	5	700	700	700	700	700	0	0	0	0	0
21	2026	8				437.5	438	438	438	438	438	438
22	2025	7			71.42857143	71	71	71	71	71	71	3
23	2024	1		2400	0	0	0	0	0	0	0	0
24	2023	10	80	80	80	80	80	80	80	80	80	80
25	2023	5	300	300	300	300	300	0	0	0	0	0
26
27				13950	3621.428571	16558.5	7939	15589	589	589	1015.4	264453
Rows to Columns

Cell Formulas
Range	Formula
F27:N27	F27	=SUM(F3:F25)+SUM(FILTER($E3:E25,$C3:$C25+$D3:$D25-1=F2,0))

 

[FirewalkerZ5]

Yes, previously I thought you only wanted rows that ended that year.

Try this

Exactly what I was looking for. Thank you so very much.

 

[Peter_SSs]

You are very welcome. Thanks for the follow-up.