How to calculate Year totals from month range without manually doing

[bbeaver8605]

$ 154,032.00

					ABC
	Customer	ABC	XYZ		Year	Date	Monthly Revenue	Monthly Cam	Totals
Year	Total Revenue				2015​	Jan-15​	$ -	$ -	$ -			Year	Year #	Date	Totals
2015​		$ -			2015​	Feb-15​	$ -	$ -	$ -			2018​	1​	Oct-18​	$ 172,836.00
2016​		$ -			2015​	Mar-15​	$ -	$ -	$ -			2018​	1​	Nov-18​	$ 172,955.00
2017​		$ -			2015​	Apr-15​	$ -	$ -	$ -			2018​	1​	Dec-18​	$ 173,078.00
2018​		$ -	$ -		2015​	May-15​	$ 51,348.00	$ 42,931.09	$ 94,279.09			2019​	1​	Jan-19​	$ 361,759.18
2019​		$ -	$ -		2015​	Jun-15​	$ 51,348.00	$ 42,931.09	$ 94,279.09			2019​	1​	Feb-19​	$ 361,884.18
2020​		$ -	$ -		2015​	Jul-15​	$ 51,348.00	$ 42,931.09	$ 94,279.09			2019​	1​	Mar-19​	$ 362,001.18
2021​		$ -	$ -		2015​	Aug-15​	$ 102,696.00	$ 42,931.09	$ 145,627.09			2019​	1​	Apr-19​	$ 464,822.18
2022​		$ -	$ -		2015​	Sep-15​	$ 102,696.00	$ 42,931.09	$ 145,627.09			2019​	1​	May-19​	$ 464,945.18
2023​		$ -	$ -		2015​	Oct-15​	$ 102,696.00	$ 42,931.09	$ 145,627.09			2019​	1​	Jun-19​	$ 465,068.18
2024​		$ -	$ -		2015​	Nov-15​	$ 102,696.00	$ 42,931.09	$ 145,627.09			2019​	1​	Jul-19​	$ 465,191.18
2025​		$ -	$ -		2015​	Dec-15​	$ 102,696.00	$ 42,931.09	$ 145,627.09			2019​	1​	Aug-19​	$ 465,314.18
2026​		$ -	$ -		2016​	Jan-16​	$ 154,032.00	$ 54,931.00	$ 208,963.00			2019​	1​	Sep-19​	$ 592,111.00
2027​		$ -			2016​	Feb-16​	$ 154,032.00	$ 54,931.00	$ 208,963.00			2019​	2​	Oct-19​	$ 592,235.00
2028​		$ -			2016​	Mar-16​	$ 154,032.00	$ 54,931.00	$ 208,963.00			2019​	2​	Nov-19​	$ 592,356.00
2029​		$ -			2016​	Apr-16​	$ 154,032.00	$ 54,931.00	$ 208,963.00			2019​	2​	Dec-19​	$ 592,479.00
2030​		$ -			2016​	May-16​	$ 154,032.00	$ 54,931.00	$ 208,963.00			2020​	2​	Jan-20​	$ 592,602.00
					2016​	Jun-16​	$ 154,032.00	$ 54,931.00	$ 208,963.00			2020​	2​	Feb-20​	$ 590,696.00
					2016​	Jul-16​	$ 154,032.00	$ 54,931.00	$ 208,963.00			2020​	2​	Mar-20​	$ 590,814.00
					2016​	Aug-16​	$ 154,032.00	$ 54,931.00	$ 208,963.00			2020​	2​	Apr-20​	$ 590,938.00
					2016​	Sep-16​	$ 54,931.00	$ 208,963.00			2020​	2​	May-20​	$ 591,060.00
					2016​	Oct-16​	$ 154,032.00	$ 54,931.00	$ 208,963.00			2020​	2​	Jun-20​	$ 591,182.00
					2016​	Nov-16​	$ 154,032.00	$ 54,931.00	$ 208,963.00			2020​	2​	Jul-20​	$ 591,304.00
					2016​	Dec-16​	$ 154,032.00	$ 54,931.00	$ 208,963.00			2020​	2​	Aug-20​	$ 591,426.00
					2017​	Jan-17​	$ 205,380.00	$ 78,775.00	$ 284,155.00			2020​	2​	Sep-20​	$ 741,934.00
					2017​	Feb-17​	$ 205,380.00	$ 78,775.00	$ 284,155.00			2020​	3​	Oct-20​	$ 742,057.00
					2017​	Mar-17​	$ 205,380.00	$ 78,775.00	$ 284,155.00			2020​	3​	Nov-20​	$ 742,175.00
					2017​	Apr-17​	$ 205,380.00	$ 78,775.00	$ 284,155.00			2020​	3​	Dec-20​	$ 742,297.00
					2017​	May-17​	$ 205,380.00	$ 78,775.00	$ 284,155.00			2021​	3​	Jan-21​	$ 742,419.00
					2017​	Jun-17​	$ 210,000.00	$ 78,775.00	$ 288,775.00			2021​	3​	Feb-21​	$ 751,783.00
					2017​	Jul-17​	$ 210,000.00	$ 78,775.00	$ 288,775.00			2021​	3​	Mar-21​	$ 751,899.00
					2017​	Aug-17​	$ 210,000.00	$ 78,775.00	$ 288,775.00			2021​	3​	Apr-21​	$ 752,023.00
					2017​	Sep-17​	$ 210,000.00	$ 78,775.00	$ 288,775.00			2021​	3​	May-21​	$ 752,145.00
					2017​	Oct-17​	$ 210,000.00	$ 78,775.00	$ 288,775.00			2021​	3​	Jun-21​	$ 752,267.00
					2017​	Nov-17​	$ 210,000.00	$ 78,775.00	$ 288,775.00			2021​	3​	Jul-21​	$ 752,389.00
					2017​	Dec-17​	$ 210,000.00	$ 78,775.00	$ 288,775.00			2021​	3​	Aug-21​	$ 752,511.00
					2018​	Jan-18​	$ 210,000.00	$ 87,154.53	$ 297,154.53			2021​	3​	Sep-21​	$ 769,394.06
					2018​	Feb-18​	$ 210,000.00	$ 87,154.53	$ 297,154.53			2021​	4​	Oct-21​	$ 769,517.06
					2018​	Mar-18​	$ 210,000.00	$ 87,154.53	$ 297,154.53			2021​	4​	Nov-21​	$ 769,635.06
					2018​	Apr-18​	$ 210,000.00	$ 87,154.53	$ 297,154.53			2021​	4​	Dec-21​	$ 769,757.06
					2018​	May-18​	$ 210,000.00	$ 87,154.53	$ 297,154.53			2022​	4​	Jan-22​	$ 769,879.06
					2018​	Jun-18​	$ 214,200.00	$ 87,154.53	$ 301,354.53			2022​	4​	Feb-22​	$ 778,403.06
					2018​	Jul-18​	$ 214,200.00	$ 87,154.53	$ 301,354.53			2022​	4​	Mar-22​	$ 778,519.06
					2018​	Aug-18​	$ 214,200.00	$ 87,154.53	$ 301,354.53			2022​	4​	Apr-22​	$ 778,643.06
					2018​	Sep-18​	$ 214,200.00	$ 87,154.53	$ 301,354.53			2022​	4​	May-22​	$ 778,765.06
					2018​	Oct-18​	$ 214,200.00	$ 87,154.53	$ 301,354.53			2022​	4​	Jun-22​	$ 778,887.06
					2018​	Nov-18​	$ 214,200.00	$ 87,154.53	$ 301,354.53			2022​	4​	Jul-22​	$ 779,009.06
					2018​	Dec-18​	$ 214,200.00	$ 87,154.53	$ 301,354.53			2022​	4​	Aug-22​	$ 779,131.06
					2019​	Jan-19​	$ 214,200.00	$ 85,225.00	$ 299,425.00			2022​	4​	Sep-22​	$ 775,396.00
					2019​	Feb-19​	$ 214,200.00	$ 85,225.00	$ 299,425.00			2022​	4​	Oct-22​	$ 775,518.00
					2019​	Mar-19​	$ 214,200.00	$ 85,225.00	$ 299,425.00			2022​	5​	Nov-22​	$ 775,637.00
					2019​	Apr-19​	$ 214,200.00	$ 85,225.00	$ 299,425.00			2022​	5​	Dec-22​	$ 775,759.00
					2019​	May-19​	$ 214,200.00	$ 85,225.00	$ 299,425.00			2023​	5​	Jan-23​	$ 775,881.00
					2019​	Jun-19​	$ 218,484.00	$ 85,225.00	$ 303,709.00			2023​	5​	Feb-23​	$ 784,573.00
					2019​	Jul-19​	$ 218,484.00	$ 85,225.00	$ 303,709.00			2023​	5​	Mar-23​	$ 784,689.00
					2019​	Aug-19​	$ 218,484.00	$ 85,225.00	$ 303,709.00			2023​	5​	Apr-23​	$ 784,813.00
					2019​	Sep-19​	$ 218,484.00	$ 85,225.00	$ 303,709.00			2023​	5​	May-23​	$ 784,935.00
					2019​	Oct-19​	$ 218,484.00	$ 85,225.00	$ 303,709.00			2023​	5​	Jun-23​	$ 785,057.00
					2019​	Nov-19​	$ 218,484.00	$ 85,225.00	$ 303,709.00
					2019​	Dec-19​	$ 218,484.00	$ 85,225.00	$ 303,709.00
					2020​	Jan-20​	$ 218,484.00	$ 85,225.00	$ 303,709.00
					2020​	Feb-20​	$ 218,484.00	$ 85,225.00	$ 303,709.00
					2020​	Mar-20​	$ 218,484.00	$ 85,225.00	$ 303,709.00
					2020​	Apr-20​	$ 218,484.00	$ 85,225.00	$ 303,709.00
					2020​	May-20​	$ 218,484.00	$ 87,392.00	$ 305,876.00
					2020​	Jun-20​	$ 222,852.00	$ 87,392.00	$ 310,244.00
					2020​	Jul-20​	$ 222,852.00	$ 87,392.00	$ 310,244.00
					2020​	Aug-20​	$ 222,852.00	$ 87,392.00	$ 310,244.00
					2020​	Sep-20​	$ 222,852.00	$ 87,392.00	$ 310,244.00
					2020​	Oct-20​	$ 222,852.00	$ 87,392.00	$ 310,244.00
					2020​	Nov-20​	$ 222,852.00	$ 87,392.00	$ 310,244.00
					2020​	Dec-20​	$ 222,852.00	$ 87,392.00	$ 310,244.00
					2021​	Jan-21​	$ 222,852.00	$ 87,392.00	$ 310,244.00
					2021​	Feb-21​	$ 222,852.00	$ 87,392.00	$ 310,244.00
					2021​	Mar-21​	$ 222,852.00	$ 87,392.00	$ 310,244.00
					2021​	Apr-21​	$ 222,852.00	$ 87,392.00	$ 310,244.00
					2021​	May-21​	$ 222,852.00	$ 87,392.00	$ 310,244.00
					2021​	Jun-21​	$ 227,316.00		$ 227,316.00
					2021​	Jul-21​	$ 227,316.00		$ 227,316.00
					2021​	Aug-21​	$ 227,316.00		$ 227,316.00
					2021​	Sep-21​	$ 227,316.00		$ 227,316.00
					2021​	Oct-21​	$ 227,316.00		$ 227,316.00
					2021​	Nov-21​	$ 227,316.00		$ 227,316.00
					2021​	Dec-21​	$ 227,316.00		$ 227,316.00
					2022​	Jan-22​	$ 227,316.00		$ 227,316.00
					2022​	Feb-22​	$ 227,316.00		$ 227,316.00
					2022​	Mar-22​	$ 227,316.00		$ 227,316.00
					2022​	Apr-22​	$ 227,316.00		$ 227,316.00
					2022​	May-22​	$ 227,316.00		$ 227,316.00
					2022​	Jun-22​	$ 231,864.00		$ 231,864.00
					2022​	Jul-22​	$ 231,864.00		$ 231,864.00
					2022​	Aug-22​	$ 231,864.00		$ 231,864.00
					2022​	Sep-22​	$ 231,864.00		$ 231,864.00
					2022​	Oct-22​	$ 231,864.00		$ 231,864.00
					2022​	Nov-22​	$ 231,864.00		$ 231,864.00
					2022​	Dec-22​	$ 231,864.00		$ 231,864.00
					2023​	Jan-23​	$ 231,864.00		$ 231,864.00
					2023​	Feb-23​	$ 231,864.00		$ 231,864.00
					2023​	Mar-23​	$ 231,864.00		$ 231,864.00
					2023​	Apr-23​	$ 231,864.00		$ 231,864.00
					2023​	May-23​	$ 231,864.00		$ 231,864.00
					2023​	Jun-23​	$ 236,496.00		$ 236,496.00
					2023​	Jul-23​	$ 236,496.00		$ 236,496.00
					2023​	Aug-23​	$ 236,496.00		$ 236,496.00
					2023​	Sep-23​	$ 236,496.00		$ 236,496.00
					2023​	Oct-23​	$ 236,496.00		$ 236,496.00
					2023​	Nov-23​	$ 236,496.00		$ 236,496.00
					2023​	Dec-23​	$ 236,496.00		$ 236,496.00
					2024​	Jan-24​	$ 236,496.00		$ 236,496.00
					2024​	Feb-24​	$ 236,496.00		$ 236,496.00
					2024​	Mar-24​	$ 236,496.00		$ 236,496.00
					2024​	Apr-24​	$ 236,496.00		$ 236,496.00
					2024​	May-24​	$ 236,496.00		$ 236,496.00
					2024​	Jun-24​	$ 241,224.00		$ 241,224.00
					2024​	Jul-24​	$ 241,224.00		$ 241,224.00
					2024​	Aug-24​	$ 241,224.00		$ 241,224.00
					2024​	Sep-24​	$ 241,224.00		$ 241,224.00
					2024​	Oct-24​	$ 241,224.00		$ 241,224.00
					2024​	Nov-24​	$ 241,224.00		$ 241,224.00
					2024​	Dec-24​	$ 241,224.00		$ 241,224.00
					2025​	Jan-25​	$ 241,224.00		$ 241,224.00
					2025​	Feb-25​	$ 241,224.00		$ 241,224.00
					2025​	Mar-25​	$ 241,224.00		$ 241,224.00
					2025​	Apr-25​	$ 241,224.00		$ 241,224.00
					2025​	May-25​	$ 241,224.00		$ 241,224.00
					2025​	Jun-25​	$ 246,048.00		$ 246,048.00
					2025​	Jul-25​	$ 246,048.00		$ 246,048.00
					2025​	Aug-25​	$ 246,048.00		$ 246,048.00
					2025​	Sep-25​	$ 246,048.00		$ 246,048.00
					2025​	Oct-25​	$ 246,048.00		$ 246,048.00
					2025​	Nov-25​	$ 246,048.00		$ 246,048.00
					2025​	Dec-25​	$ 246,048.00		$ 246,048.00
					2026​	Jan-26​	$ 246,048.00		$ 246,048.00
					2026​	Feb-26​	$ 246,048.00		$ 246,048.00
					2026​	Mar-26​	$ 246,048.00		$ 246,048.00
					2026​	Apr-26​	$ 246,048.00		$ 246,048.00
					2026​	May-26​	$ 246,048.00		$ 246,048.00

 

[yky]

For 2015 ABC, try this:

=SUMPRODUCT(--(F$5:F$140=A5),(J$5:J$140))

You can copy it down the column to get the total for other years.

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1		Customer	ABC	XYZ		Year	Date	Monthly Revenue	Monthly Cam	Totals
2	Year	Total Revenue				2015	15-Jan						Year	Year #	Date	Totals
3	2015	1,010,972.72				2015	15-Feb						2018	1	18-Oct	172,836.00
4	2016	2,507,556.00				2015	15-Mar						2018	1	18-Nov	172,955.00
5	2017	3,442,200.00				2015	15-Apr						2018	1	18-Dec	173,078.00
6	2018	3,595,254.36				2015	15-May	51,348.00	42,931.09	94,279.09			2019	1	19-Jan	361,759.18
7	2019	3,623,088.00				2015	15-Jun	51,348.00	42,931.09	94,279.09			2019	1	19-Feb	361,884.18
8	2020	3,692,420.00				2015	15-Jul	51,348.00	42,931.09	94,279.09			2019	1	19-Mar	362,001.18
9	2021	3,142,432.00				2015	15-Aug	102,696.00	42,931.09	145,627.09			2019	1	19-Apr	464,822.18
10	2022	2,759,628.00				2015	15-Sep	102,696.00	42,931.09	145,627.09			2019	1	19-May	464,945.18
11	2023	2,814,792.00				2015	15-Oct	102,696.00	42,931.09	145,627.09			2019	1	19-Jun	465,068.18
12	2024	2,871,048.00				2015	15-Nov	102,696.00	42,931.09	145,627.09			2019	1	19-Jul	465,191.18
13	2025	2,928,456.00				2015	15-Dec	102,696.00	42,931.09	145,627.09			2019	1	19-Aug	465,314.18
14	2026	1,230,240.00				2016	16-Jan	154,032.00	54,931.00	208,963.00			2019	1	19-Sep	592,111.00
15	2027	0.00				2016	16-Feb	154,032.00	54,931.00	208,963.00			2019	2	19-Oct	592,235.00
16	2028	0.00				2016	16-Mar	154,032.00	54,931.00	208,963.00			2019	2	19-Nov	592,356.00
17	2029	0.00				2016	16-Apr	154,032.00	54,931.00	208,963.00			2019	2	19-Dec	592,479.00
18	2030	0.00				2016	16-May	154,032.00	54,931.00	208,963.00			2020	2	20-Jan	592,602.00
19						2016	16-Jun	154,032.00	54,931.00	208,963.00			2020	2	20-Feb	590,696.00
20						2016	16-Jul	154,032.00	54,931.00	208,963.00			2020	2	20-Mar	590,814.00
21						2016	16-Aug	154,032.00	54,931.00	208,963.00			2020	2	20-Apr	590,938.00
22						2016	16-Sep	54,931.00	54,931.00	208,963.00			2020	2	20-May	591,060.00
23						2016	16-Oct	154,032.00	54,931.00	208,963.00			2020	2	20-Jun	591,182.00
24						2016	16-Nov	154,032.00	54,931.00	208,963.00			2020	2	20-Jul	591,304.00
25						2016	16-Dec	154,032.00	54,931.00	208,963.00			2020	2	20-Aug	591,426.00
26						2017	17-Jan	205,380.00	78,775.00	284,155.00			2020	2	20-Sep	741,934.00
27						2017	17-Feb	205,380.00	78,775.00	284,155.00			2020	3	20-Oct	742,057.00
28						2017	17-Mar	205,380.00	78,775.00	284,155.00			2020	3	20-Nov	742,175.00
29						2017	17-Apr	205,380.00	78,775.00	284,155.00			2020	3	20-Dec	742,297.00
30						2017	17-May	205,380.00	78,775.00	284,155.00			2021	3	21-Jan	742,419.00
31						2017	17-Jun	210,000.00	78,775.00	288,775.00			2021	3	21-Feb	751,783.00
32						2017	17-Jul	210,000.00	78,775.00	288,775.00			2021	3	21-Mar	751,899.00
33						2017	17-Aug	210,000.00	78,775.00	288,775.00			2021	3	21-Apr	752,023.00
Result

Cell Formulas
Range	Formula
B3:B18	B3	=SUMIFS(J:J,F:F,A3)

 

[bbeaver8605]

both work. i was trying to make it more complicated. thanks

 

[Fluff]

Glad we could help & thanks for the feedback.