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!!!
Bookmarks