How do I designate a number in one table and add them up in another.
Can someone please help me do this. I dont even know what to call it. Conditional categorization?
I have a table with costs, and another table to separate them into categtroies as shown:
I want to be able to enter a category in the green column, and have those nunmber appear and total up in the COST TOTALS in the second table.
What formula do I put in the COST TOTALS cells?