Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excluding only leading or trailing cells from a column
I have a column, say A, that I want to SUM(). I want to avoid including A1:A3
in this sum - unfortunately, the length of the data in the column at any time is indeterminate. So I can't SUM(A4:AX)... And I can't SUM(A4:A), although that seems intuitive to me. Help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excluding only leading or trailing cells from a column
Would =SUM(A:A)-SUM(A1:A3) work?
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "PaladinWhite" wrote in message ... I have a column, say A, that I want to SUM(). I want to avoid including A1:A3 in this sum - unfortunately, the length of the data in the column at any time is indeterminate. So I can't SUM(A4:AX)... And I can't SUM(A4:A), although that seems intuitive to me. Help? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excluding only leading or trailing cells from a column
Or possibly =SUM($A$4:INDEX(A:A,ROW()-1))
Gord Dibben MS Excel MVP On Sun, 21 Oct 2007 13:47:06 -0300, "Bernard Liengme" wrote: Would =SUM(A:A)-SUM(A1:A3) work? best wishes |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excluding only leading or trailing cells from a column
Excluding only leading or trailing cells from a column
You've explained about excluding the leading cells A1:A3 but what do you mean when you say exclude trailing cells? What trailing cells? -- Biff Microsoft Excel MVP "PaladinWhite" wrote in message ... I have a column, say A, that I want to SUM(). I want to avoid including A1:A3 in this sum - unfortunately, the length of the data in the column at any time is indeterminate. So I can't SUM(A4:AX)... And I can't SUM(A4:A), although that seems intuitive to me. Help? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excluding only leading or trailing cells from a column
D'oh - I can't believe something that simple eluded my grasp. That's
precisely what I need to do. Thanks. "Bernard Liengme" wrote: Would =SUM(A:A)-SUM(A1:A3) work? best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "PaladinWhite" wrote in message ... I have a column, say A, that I want to SUM(). I want to avoid including A1:A3 in this sum - unfortunately, the length of the data in the column at any time is indeterminate. So I can't SUM(A4:AX)... And I can't SUM(A4:A), although that seems intuitive to me. Help? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excluding only leading or trailing cells from a column
Sorry, I guess the title was a bit misleading. The "or trailing" part was
simply tacked on because I initially thought the solution would probably be similar whether the cells to be excluded were leading or trailing - now that I think about it, if I needed to exclude trailing cells, I would already know the length of the data column, and I could just use SUM(A1:AX). "T. Valko" wrote: Excluding only leading or trailing cells from a column You've explained about excluding the leading cells A1:A3 but what do you mean when you say exclude trailing cells? What trailing cells? -- Biff Microsoft Excel MVP "PaladinWhite" wrote in message ... I have a column, say A, that I want to SUM(). I want to avoid including A1:A3 in this sum - unfortunately, the length of the data in the column at any time is indeterminate. So I can't SUM(A4:AX)... And I can't SUM(A4:A), although that seems intuitive to me. Help? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excluding only leading or trailing cells from a column
Ok, thanks for the clarification.
-- Biff Microsoft Excel MVP "PaladinWhite" wrote in message ... Sorry, I guess the title was a bit misleading. The "or trailing" part was simply tacked on because I initially thought the solution would probably be similar whether the cells to be excluded were leading or trailing - now that I think about it, if I needed to exclude trailing cells, I would already know the length of the data column, and I could just use SUM(A1:AX). "T. Valko" wrote: Excluding only leading or trailing cells from a column You've explained about excluding the leading cells A1:A3 but what do you mean when you say exclude trailing cells? What trailing cells? -- Biff Microsoft Excel MVP "PaladinWhite" wrote in message ... I have a column, say A, that I want to SUM(). I want to avoid including A1:A3 in this sum - unfortunately, the length of the data in the column at any time is indeterminate. So I can't SUM(A4:AX)... And I can't SUM(A4:A), although that seems intuitive to me. Help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting non-blank cells in a column, excluding hidden rows | Excel Worksheet Functions | |||
Removing leading/trailing spaces | Excel Discussion (Misc queries) | |||
How keep Leading/Trailing spaces when save in Excel? | Excel Discussion (Misc queries) | |||
How to save Excel string data without the leading/trailing DQ (")s | Excel Discussion (Misc queries) | |||
Removing trailing spaces from cells ? | Excel Worksheet Functions |