I’m creating a spreadsheet for work and have run into an issue.
In my work, we allocate ourselves documents to process every few minutes. I’ve managed to create a spreadsheet which tracks how many are being processed daily, and by whom the documents are being process (so each individual can see how much they did on a specific day).
My issue is that we sometimes finish work with some documents left to process, which we can just process the day after; however, we make a note of these documents the day after.

Because we make a note of the documents, and write them down, we technically ‘add’ to the amount on the sheet. For example, someone can be allocated 20 documents the day before, but then have 4 left when they finish, so someone will write down that there were 4 from the last day, but the amount will be in the same column as the amount that was allocated.
This means that the formula I have in place would count the total as 24, when it’s really 16+4.

Is there any way of creating a formula which, when a box next to the amount has a specific phrase input into it, will cause the amount to be exempt from the formula which calculates totals, but still be visible as if it were a normal number?