Hey guys,

I need assistance writing two formulas into two different columns in a table in Excel. Now, I know some people warn against doing that. However, the worksheet gets sent to all team members in my company to keep track of cost/profit/projects coming in and out. Consequently, building out a VLookUp or something else doesn't work. Below is the code, everything that I have tried is marked as comments. The table that needs the added formula is 16 columns wide, and there is a second table in the worksheet that draws information from the first table-it is like a shorthand version.

I need one formula to add up three columns-- phone cost, data cost, and commission cost--which are in columns 12,13, and 14. The formula should go into column 15 (Total Cost)
The second formula subtracts the Total Cost (column 15) from the Invoice Amount (column 4), and places it in Profit (column 16).

Please Login or Register  to view this content.
The other thought I had was to write out everything I need everyday, and then convert the range to a table using the macro. But I don't know if that is necessarily easier or better.

Any guidance on the matter would be appreciated, I have been playing around for a day or two to no avail.

Cheers,
Rachelle