Excel - SUMIF Exclude Certain Cell

Asked By Step on 23-Feb-08 11:39 AM
I would like to write a formula that sums the values in cells A1:A5 while
excluding the value in cell A3 only.

For example:

A1 = 2
A2 = 6
A3 = 6
A4 = 2
A5 = 2

The formula would return 12.  If the value in A3 changes to 10, the formula
would still return 12.

Thanks again for your help.  And thanks to those who helped me with my
earlier post.

--
Steph




Stan Brown replied on 23-Feb-08 11:47 AM
Sat, 23 Feb 2008 08:39:01 -0800 from Steph

=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?
Don Guillett replied on 23-Feb-08 11:51 AM
=sum(a1:a5)-a3

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
Ron Rosenfeld replied on 23-Feb-08 11:51 AM
=a1+a2+a4+a5

--ron