I am having trouble with two things:
Thing 1: I have created a auto calculating inventory sheet for my business. It shows inventory cost ,Profit and quantity on hand. When you enter quanity sold it totals up sales and profit, If the Item is sold out and not avaliable anymore and I have to remove the line item.When I remove the item it subtracts from the inventory cost and profit . Is there a way to make the profit totals where it does not subtract when removing a line item