Sum cells based on years in cells

[Hydestone]

Hi All:

I am trying to write a formula that sums up the values in columns I & J, if the date in column A falls with a particular year listed up in column G. Any ideas?

Solar Payback Calculator.xlsx
	A	B	C	D	E	F	G	H	I	J
1	System Size	12.92	kW DC			avoided cost
2	Total Cost	25,866.67		2.00206424		2022
3	Federal Incentive	(8,000.00)	check this			2023
4	State incentive	(1,000.00)	check this			2024
5	Other Incentive	-				2025
6	Net Cost	16,866.67				2026
7	Savings to Date	-				2027
8		16,866.67				2028
9
10	bill date	net usage (kWh)	production (kWh)	avoided (kWh)	distribution ($/kWh)	net meter ($/kWh)	customer charge	total bill	SMART credit	avoided cost
11	9/1/2020	889	0	0	0.00341	0.00000	7.00	7.00	0.00	0.00
12	10/1/2020	773	0	0	0.00341	0.00000	7.00	7.00	0.00	0.00
13	11/1/2020	869	0	0	0.00341	0.00000	7.00	7.00	0.00	0.00
14	12/1/2020	1,571	0	0	0.00341	0.00000	7.00	7.00	0.00	0.00
15	1/1/2021	1,924	0	0	0.00341	0.00000	7.00	7.00	0.00	0.00
16	2/1/2021	1,741	0	0	0.00341	0.00000	7.00	7.00	0.00	0.00
17	3/1/2021	1,491	0	0	0.00341	0.00000	7.00	7.00	0.00	0.00
18	4/1/2021	1,556	0	0	0.00341	0.00000	7.00	7.00	0.00	0.00
19	5/1/2021	1,141	0	0	0.00341	0.00000	7.00	7.00	0.00	0.00
20	6/1/2021	1,266	0	0	0.00341	0.00000	7.00	7.00	0.00	0.00
21	7/1/2021	872	0	0	0.00341	0.00000	7.00	7.00	0.00	0.00
22	8/1/2021	807	0	0	0.00341	0.00000	7.00	7.00	0.00	0.00
23	9/9/2021	994	0	0	0.00341	0.23381	7.00	239.41	0.00	0.00
24	10/7/2021	836	0	0	0.00341	0.23382	7.00	202.47	0.00	0.00
25	11/8/2021	1,145	0	0	0.00341	0.23381	7.00	274.71	0.00	0.00
26	12/9/2021	1,517	0	0	0.00341	0.23382	7.00	361.70	0.00	0.00
27	1/7/2022	1,533	0	0	0.00341	0.24429	7.00	381.50	0.00	0.00
28	2/8/2022	1,803	0	0	0.00341	0.29451	7.00	538.01	0.00	0.00
29	3/14/2022	1,544	0	0	0.00341	0.29452	7.00	461.74	0.00	0.00
30	4/7/2022	879	1,076	1,076	0.00341	0.29452	7.00	269.55	(75.32)	(316.90)
31	5/10/2022	(54)	1,119	1,065	0.00341	0.27333	7.00	(4.13)	(78.33)	(291.10)
32	6/9/2022	(686)	1,527	841	0.00341	0.27347	7.00	(177.73)	(106.89)	(229.99)
33	7/11/2022	(520)	1,442	922	0.00341	0.27844	7.00	(134.64)	(100.94)	(256.72)
34	8/10/2022	(256)	1,451	1,195	0.00341	0.29547	7.00	(64.57)	(101.57)	(353.09)
35		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
36		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
37		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
38		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
39		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
40		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
41		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
42		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
43		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
44		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
45		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
46		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
47		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
48		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
49		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
50		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
51		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
52		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
53		0	0	0	0.00000	0.00000	0.00	0.00	0.00	0.00
54
55	Warranty Information
56	System Repairs	20	years
57	Labor and Workmanship	20	years
58	Solar panels	12	years
59	Roof	10	years
60
61	Estimated 1st year production	10,818	kWh
Sheet1

Cell Formulas
Range	Formula
D2	D2	=B2/(B1*1000)
B6	B6	=SUM(B2:B5)
B7	B7	=SUM(I36:J36)
B8	B8	=SUM(B6:B7)
H11:H53	H11	=G11+(D11*E11)+(B11*F11)
I11:I53	I11	=C11*-0.07
J11:J53	J11	=D11*-F11
F23	F23	=(239.41-7)/994
F24	F24	=(202.47-7)/836
F25	F25	=(274.71-7)/1145
F26	F26	=(361.7-7)/1517
F27	F27	=(381.5-7)/1533
F28	F28	=(538.01-7)/1803
F29	F29	=(461.74-7)/1544
F30	F30	=0.07056-0.00177+0.04437+0.00267+0.00341+0.0005+0.01714+0.15764
D11:D34	D11	=IF((B11>0),(C11),(B11+C11))
D35:D53	D35	=B35+C35

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B11:J53	Cell Value	=0	text	NO

 

[Hydestone]

trying to come up with a payback calculator. Any other sheet formulas or improvements would be appreciated!