Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Exclude Certain Cell
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Exclude Certain Cell
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Exclude Certain Cell
On Sat, 23 Feb 2008 08:39:01 -0800, Steph
wrote: 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. =a1+a2+a4+a5 --ron |
#5
|
|||
|
|||
Hello! My question is the same with Ron's, but I would like to exclude the cell that contains the formula that calculates the average. This cell will change every week (a row down) . How can I do this?
Thank you in advance for your answer! ;) Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
charts exclude cell with formula | Charts and Charting in Excel | |||
Exclude Cell from Calculation | Excel Discussion (Misc queries) | |||
How to exclude single cell from printing | Excel Discussion (Misc queries) | |||
How do I exclude a cell from an average calculation when the cell. | Excel Discussion (Misc queries) | |||
Exclude a cell from calculating | Excel Worksheet Functions |