RedBeard,

Array enter (Enter using Ctrl-Shift-Enter) a formula like

=SUM(IF(A1:A10<10,A1:A10))

where 10 is the value that you want ignored.

A non-array entered formula would be

=SUMPRODUCT((A1:A10<10)*A1:A10)


HTH,
Bernie
MS Excel MVP


"RedBeard" wrote in message
...
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?