Excluding Cells in Calculation

[d3vinw]

I am relatively new to Excel, I know the basics but that is about it. Basically what I am doing is creating a cash sheet to record totals from tills, and than at the end do a tally, but I've made it so that once a cell has been edited, it cannot be changed, this is great so numbers cannot be fudged, however, if a mistake is made, I want that row to still be there(for viewing purposes only), but not included in the tally (each column will have it's own tally) Therefore I need to be able to add up these columns, excluding the rows that have errors (like the wrong number entered) so what I was thinking is there a way to make it like this:

I dont know the coding, but basically create a new column called exclude, and if there is a Y or a 1 or something in that clumn, the row that it is in will be excluded from the end column tallys

I hope this makes sense.. lol

 

[Dryver14]

something like below will do that

where column E is sum column and F has a y in cells to be excluded

=SUMIF(F3:F11,"",E3:E11)

 

[d3vinw]

Worked like a charm.. thank you!