If you taking one of each value then new value is:

=SUM(A:A)-count(A:A)

and new average is

=-1+SUM(A:A)/count(A:A)