Sumif formula that exclueds duplicates

[lesoies]

I need a formula that will provide the 'Total' results below:

Issues-For future 1, project A is included twice, I only want it in the total once. But when I sum for future 3, project A is here as well, I do want it included in the total for future 3 as well.

Future Project Cost
1 A 100
1 A 100
2 B 110
3 C 120
4 A 100
1 B 110
2 C 120
3 A 100
4 B 110
1 C 120

Totals
Future 1 330 I need a formula that will provide these results
Future 2 230
Future 3 220
Future 4 210


Ok, so I am able to get this to work if I do the formula on the same tab, but I want my summary page as a separate tab, this is where I have issues...
Thank you!!!

[Miraun]

You have a two options I can think of offhand.

You can determine if it's a repeat by using a COUNTIF function in an additional column on your data, and then adding in a provision on your sumifs.
Or you could filter for uniques using the option in the DATA tab, and then run the metrics.

[oeldere]

a pivot table will do that for you.

see the attached file.

[shadrack]

Try this one

2012-10-24 excel forumSH.xls

[e.isayev]

I think most proper way is to add helper column by using countifs which has been recommended

[lesoies]

a pivot table will do that for you.

see the attached file.

Thanks, but this counts project A in future 1 twice.

[oeldere]

I changed the table.

See the pivot table in the attached file.