Thread
:
Excluding numbers in a total
View Single Post
#
4
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Excluding numbers in a total
must be homework since asked already today.
=sum(a1:a21)-a10
--
Don Guillett
SalesAid Software
"dj" wrote in message
...
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.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett