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:

1Beg Date	6/13/18
2End Date	6/12/19
3	2018-2019
4
5
6 7
8Camp Card Income	$ -
9Donation Income	$ -
10Popcorn Income	$ -
11Honey Income	$ -
12Total Income	$ -

<tbody>
</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.