=SUMIFS help matching 2 names

[zone709]

Hi, Sheet1 would be where my data is at. I need to get the Sum total on Sheet2 if the name and class code match the same name and class code on Sheet1.
I highlighted in yellow what to match and sum up the total on Sheet1. Formula would be in Sheet2 Column D. any help would be great.

Book2
	A	B	C	D
1	Name	Gross Amount	Class code	Formula Below
2	Street		Super	156.33
3	Address		Labor	52.62
4
5
6
7
8
9
10
Sheet2

Book2
	A	B	C	D
1	blank	Code	Class Code	Gross
2	empty	Street	Super	25.23
3		Street	Super	50.23
4		Address	Labor	52.62
5		Street	Super	45.26
6		Street	Super	12.56
7		Street	Super	23.05
8
9
Sheet1

 

[AhoyNC]

Try:

Book1
	A	B	C	D
1	Name	Gross Amount	Class code	Formula Below
2	Street		Super	156.33
3	Address		Labor	52.62
Sheet2

Cell Formulas
Range	Formula
D2:D3	D2	=SUMIFS(Sheet1!$D$2:$D$7,Sheet1!$B$2:$B$7,A2,Sheet1!$C$2:$C$7,C2)

Book1
	A	B	C	D
1	blank	Code	Class Code	Gross
2	empty	Street	Super	25.23
3		Street	Super	50.23
4		Address	Labor	52.62
5		Street	Super	45.26
6		Street	Super	12.56
7		Street	Super	23.05
Sheet1

 

[Sergius]

As an option

Book1
	A	B	C	D
1	Name	Gross Amount	Class code	Formula Below
2	Street		Super	156,33
3	Address		Labor	52,62
Sheet2

Cell Formulas
Range	Formula
A2:A3	A2	=UNIQUE(Sheet1!B2:B7)
C2:C3	C2	=UNIQUE(FILTER(Sheet1!C2:C7,Sheet1!B2:B7=A2))
D2:D3	D2	=SUMIFS(Sheet1!D2:D7,Sheet1!B2:B7,A2,Sheet1!C2:C7,C2)
Dynamic array formulas.

Book1
	A	B	C	D
1	blank	Code	Class Code	Gross
2	empty	Street	Super	25,23
3		Street	Super	50,23
4		Address	Labor	52,62
5		Street	Super	45,26
6		Street	Super	12,56
7		Street	Super	23,05
Sheet1

 

[zone709]

Thanks guys for the help.

 

[Sergius]

If this solves your problem, give her the status solved.