Please help. And also please be patient with me as I am having to write this thread from my phone.
So I am working on a cost build up sheet to calculate cashflow and overall costs for a project. Column A consists of a number of work tasks. Eg erect scaffold, mechanically remove rust, jet wash, add primer, add finish paint. Column B is used to assign the costs of the work in Column A with one of 10 categories described elsewhere. But for example. 1 is scaffold. 2 is prep. 3 is paint. Columns C to G are used to capture costs associated with Column A from weeks 1 to 5 of the project. At the bottom row in columns C to G I can autosum the cashflow for each week. Straightforward (even for me) so far.
What I would like to add on a separate sheet is a formula that totals all of the costs in columns c to g with each of the 10 work categories as specified in Column B. So, for example, I can see at a glance all project costs for work category 2 which is prep. Any help with this would be much appreciated.
Bookmarks