I am working on a spreadsheet for my husband so he can keep track of profit from his business.
I have cells that are adding the costs and subtracting by the sale price and then multiplying by how many sold to see the profit. Here is the formula:
=(H2-(E2+F2+G2))*I2
Well I am trying to get a running total of all the profits but when I try =SUM and highlight the column with cells that have the above formula, it doesn't give me any value, just gives me error msg. (#VALUE) or something like that.
Is there any way of adding a bunch of cells that each have a formula? There is no text in the formula so I'm not sure why it's not working.
Hope this is clear enough. I attached the spreadsheet just in case. Trying to get a TOTAL amount by adding everything in column K.
Thanks in advance.
Bookmarks