Sat, 23 Feb 2008 08:39:01 -0800 from Steph
:
I would like to write a formula that sums the values in cells A1:A5 while
excluding the value in cell A3 only.

=sum(A1:A5)-A3

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
A: Maybe because some people are too annoyed by top posting.
Q: Why do I not get an answer to my question(s)?
A: Because it messes up the order in which people normally read text.
Q: Why is top posting such a bad thing?