Formula help with two sheets

[Shetara]

Hello I need a formula to bring info over to another sheet with 3 unique identifiers:

Data on Sheet 1 - (Where the formula will be copied into to populate data)

Org	Number	Class	Type	Funding
OGH	217	11.23	18659
GHI	217	11.45	18659
SMI	217	11.36	78659
OGH	217	12	18648

<tbody>
</tbody>

Data source:

Org	Number	Class	Type	funding
OGH	217	11.2	18659	$20
GHI	217	11.45	18659	$56
GHI	217	11.36	78659	$449
OGH	217	12	18648

<tbody>
</tbody>

 

[Marcelo Branco]

Try SUMIFS
What are the 3 identifiers? Org, Number and Type?

M.

 

[Shetara]

Yes the three identifiers are Org, Number, and Type.

Also, not that the Class column in one sheet 11.23 and the other is saying 11.2 but mean the same.

 

[Marcelo Branco]

Assuming the the second sheet name is Data (adjust to suit), maybe...

E2 copied down
=SUMIFS(Data!E:E,Data!A:A.A2,Data!B:B,B2,Data!D:D,D2)

Hope this helps

M.