Thread
:
SUMIF Exclude Certain Cell
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
SUMIF Exclude Certain Cell
=sum(a1:a5)-a3
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Steph" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett