Formula to sum quarters with current formula

[1AG]

I have a current formula which returns value by month using 1-12 for months...I am needing the formula to return value by quarter as well. The formula I use is SUM((MONTH(Sheet!1$G:$G)=Report!AC2)*(Sheet!1$J:$J=Report!C$2)*(Sheet1!$B:$B=Report!$B5)*(Sheet!1$E:$E))

Report!AC2=4 (April) 1 Qtr = 1,2,3 2 Qtr =4,5,6


The other formula I have been trying to use is SUMPRODUCT((ROUNDUP(MONTH(Sheet!1$G:$G)/3,0)=1)*(Sheet!1$G:$G))

Have been working on for several days now!Thank you in advance!!

 

[1AG]

The other formula I have been trying to use is SUMPRODUCT((ROUNDUP(MONTH(Sheet!1$G:$G)/3,0)=1)*(Sheet!1$E:$E))

 

[AhoyNC]

Try just using the range of your actual data and not whole column references.

Book1
	A	B	C	D	E	F
1	Month/Year	Amount		Qtr	2019	2020
2	1/1/2019	198		1	1915	2084
3	2/1/2019	994		2	1651	1968
4	3/1/2019	723		3	2062	1915
5	4/1/2019	711		4	1086	1569
6	5/1/2019	148		1	1915	2084
7	6/1/2019	792		2	1651	1968
8	7/1/2019	815		3	2062	1915
9	8/1/2019	363		4	1086	1569
10	9/1/2019	884
11	10/1/2019	171
12	11/1/2019	406
13	12/1/2019	509
14	1/1/2020	622
15	2/1/2020	620
16	3/1/2020	842
17	4/1/2020	638
18	5/1/2020	758
19	6/1/2020	572
20	7/1/2020	706
21	8/1/2020	788
22	9/1/2020	421
23	10/1/2020	226
24	11/1/2020	384
25	12/1/2020	959
Sheet2

Cell Formulas
Range	Formula
E2:F9	E2	=SUMPRODUCT((ROUNDUP(MONTH($A$2:$A$25)/3,0)=$D2)*(YEAR($A$2:$A$25)=E$1)*($B$2:$B$25))

 

[1AG]

Try just using the range of your actual data and not whole column references.

Book1
	A	B	C	D	E	F
1	Month/Year	Amount		Qtr	2019	2020
2	1/1/2019	198		1	1915	2084
3	2/1/2019	994		2	1651	1968
4	3/1/2019	723		3	2062	1915
5	4/1/2019	711		4	1086	1569
6	5/1/2019	148		1	1915	2084
7	6/1/2019	792		2	1651	1968
8	7/1/2019	815		3	2062	1915
9	8/1/2019	363		4	1086	1569
10	9/1/2019	884
11	10/1/2019	171
12	11/1/2019	406
13	12/1/2019	509
14	1/1/2020	622
15	2/1/2020	620
16	3/1/2020	842
17	4/1/2020	638
18	5/1/2020	758
19	6/1/2020	572
20	7/1/2020	706
21	8/1/2020	788
22	9/1/2020	421
23	10/1/2020	226
24	11/1/2020	384
25	12/1/2020	959
Sheet2

Cell Formulas
Range	Formula
E2:F9	E2	=SUMPRODUCT((ROUNDUP(MONTH($A$2:$A$25)/3,0)=$D2)*(YEAR($A$2:$A$25)=E$1)*($B$2:$B$25))

Thank you!