How to gather total cost without repeating the same cell value from different columns

[annasv]

Hello everybody

So I am trying to gather total cost for a project, so in one sheet called "Cost" I have a tables for itemized cost and in another sheet called "Results" I am trying to gather cost that I have selected from different tables in the Cost sheet. So in the Results sheet, I have made a table with selected cost that have the following commands;

=IF(D9="No";Cost!D12+Cost!D14+Cost!D37+Cost!D44+Cost!D50;"0"))

=IF(D11="No";Cost!D14+Cost!D89;"0")

=IF(D13="No";Cost!N12+Cost!D44+Cost!D77+Cost!D89;"0")

So if the Cell in the D column says No the cost should be 0, but if not the cost should be shown in the F column.

My problem is that I want to show below the total cost of it all but I don't want the same cost to be repeated, so for example: Cost!D44 is in the top and the bottom command and I only want it to be shown one time in the total cost. This example was just for the shortest table, I also have one that requires 7 columns and has up to 10 different cells from the Cost sheet repeated, so I am wondering if it would be better to use VBA instead, and if so how could I do that?

Hope you can understand what I am trying to explain!

 

[bobsan42]

I am honestly lost ...
I wouldn't even try to understand it without seeing it. All kinds of formulas can be made, but i just can't see the logic in summing scattered cells.
But it seems to me like a poor data design.
Imho you don't need many tables for costs. Just one is probably perfectly enough.
Wolud you care to elaborate and maybe provide some sample data.