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)

[TABLE="width: 500"]
<tbody>[TR]
[TD]Org[/TD]
[TD]Number[/TD]
[TD]Class[/TD]
[TD]Type[/TD]
[TD]Funding[/TD]
[/TR]
[TR]
[TD]OGH[/TD]
[TD]217[/TD]
[TD]11.23[/TD]
[TD]18659[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]GHI[/TD]
[TD]217[/TD]
[TD]11.45[/TD]
[TD]18659[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]SMI[/TD]
[TD]217[/TD]
[TD]11.36[/TD]
[TD]78659[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]OGH[/TD]
[TD]217[/TD]
[TD]12[/TD]
[TD]18648[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Data source:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Org[/TD]
[TD]Number[/TD]
[TD]Class[/TD]
[TD]Type[/TD]
[TD]funding[/TD]
[/TR]
[TR]
[TD]OGH[/TD]
[TD]217[/TD]
[TD]11.2[/TD]
[TD]18659[/TD]
[TD]$20[/TD]
[/TR]
[TR]
[TD]GHI[/TD]
[TD]217[/TD]
[TD]11.45[/TD]
[TD]18659[/TD]
[TD]$56[/TD]
[/TR]
[TR]
[TD]GHI[/TD]
[TD]217[/TD]
[TD]11.36[/TD]
[TD]78659[/TD]
[TD]$449[/TD]
[/TR]
[TR]
[TD]OGH[/TD]
[TD]217[/TD]
[TD]12[/TD]
[TD]18648[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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.