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)
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)
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks