Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 - SUM Formula - exclude cell
I have some cells that do a SUM calculation on the cells immediately above
(same column). I want to do the SUM calculation but I want to EXCLUDE one specific cell. How do I do that? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 - SUM Formula - exclude cell
You could use the following =SUM(D7:D8,D10:D11) this would exclude D9 in the calculations. -- intruder9 ------------------------------------------------------------------------ intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107 View this thread: http://www.excelforum.com/showthread...hreadid=497946 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 - SUM Formula - exclude cell
Just subtract that cell from the overall sum
=SUM(A1:M1)-G1 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Peppermint" wrote in message ... I have some cells that do a SUM calculation on the cells immediately above (same column). I want to do the SUM calculation but I want to EXCLUDE one specific cell. How do I do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create different hyperlinks within one cell in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) | |||
edit formula bar in excel 2003? | New Users to Excel | |||
EDIT FORMULA BAR in excel 2003? why not? where is it? | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |