Utter newbie here so please forgive stupid questions.

I have a column with values that I would like to sum up, so far no
problem.

However, if someone enters a specific number, this cell is to be
ignored and excluded from the total sum.

Can this be done somehow?