Sum totals of amounts within a date Range by category

[nularry]

I have a data base with dates in column C, Category in column G, and Amounts in column R. On a sheet2 I have the start date in B2 and end date in B3 and in Column A I have the category names. In column B, I want to get the totals from column G (sheet 1) for rows within the date range and match the category name. This is for my Cub Scout Finances. Thank you for any help.




Sheet 2:

8Camp Card Income

9Donation Income

10Popcorn Income

11Honey Income

<tbody>
[TD="class: xl73"]1Beg Date[/TD]
[TD="class: xl71, width: 66"]6/13/18[/TD]

[TD="class: xl73, width: 158"]2End Date[/TD]
[TD="class: xl71"]6/12/19[/TD]

[TD="class: xl73, width: 158"]3[/TD]
[TD="class: xl72"]2018-2019[/TD]

[TD="class: xl68"]4[/TD]
[TD="class: xl70"][/TD]

[TD="class: xl68"]5[/TD]
[TD="class: xl70"][/TD]

[TD="class: xl68"]6
7[/TD]
[TD="class: xl70"][/TD]

[TD="class: xl69"] $ -[/TD]

[TD="class: xl69"] $ -[/TD]

[TD="class: xl69"] $ -[/TD]

[TD="class: xl69"] $ -[/TD]

[TD="class: xl68"]12Total Income[/TD]
[TD="class: xl70"] $ - [/TD]

</tbody>

 

[jtakw]

Hi,

Change/adjust cell references/range, add sheet Name, as needed.

You may Also have to Change the "Category" names in Sheet1 and/or Sheet2 to match each other:

Book1
	A	B	C	D	G	H	R
1	Beg Date	6/13/2018	6/1/2018		Camp Card Income		$100
2	End Date	6/12/2019	7/2/2018		Donation Income		$200
3		2018-2019	10/15/2018		Popcorn Income		$300
4			5/30/2019		Honey Income		$400
5			7/4/2019		Donation Income		$500
6
7
8	Camp Card Income	0
9	Donation Income	200
10	Popcorn Income	300
11	Honey Income	400
12	Total Income	900
Sheet587

Cell Formulas
Range	Formula
B8	=SUMIFS(R$1:R$5,C$1:C$5,">="&B$1,C$1:C$5,"<="&B$2,G$1:G$5,A8)
B12	=SUM(B8:B11)

B8 formula copied down to B11

 

[nularry]

Thank you jtakw. That worked.

 

[jtakw]

You're welcome.