Adding numbers from a list over a specific value

Giganews Newsgroups
Subject: Adding numbers from a list over a specific value
Posted by:  Herd96
Date: Mon, 15 May 2006

This should be rather simple, but I'm not getting it.  I have a list of 15
numbers, six of whom are over 10.  For the numbers over ten, I need to add
the difference between those numbers and 10.  For instance, it my list had
12, 11, 13, and 10, I would need excel to add 2+1+3 in a manner where I would
not need to add an additional column or row, just entering a formula in a
single cell.

Replies