I have a small spreadsheet to track the total cost of something. I have cells
C6:C19 with dollar amounts in them. I have cell
C21 showing that total. I've created a conditional rule for the cells
B6:B19. But if I put an X in those cells, it strikes out the value in column
Now I'd like when I put an x in that it also subtracts that amount from the total in cell
C21, but I can't figure out how to do so.