=SUM(A1:A10)-A6


Gord Dibben MS Excel MVP

On Mon, 10 Jul 2006 16:18:02 -0700, dj wrote:

Is there a way to show a number in a column, yet not have it included in the
total?
The example would be to show how much an item would cost but strike it out
because that item is being included at no charge. This is for Excel 2000.

Thanks for any help.