Does it get any simpler than this?

  • Thread starter Thread starter Terry B.
  • Start date Start date
T

Terry B.

I confess that I'm new to Excel, which might account for the fact that
this question is painfully-simple to answer, but here goes anyway!
ALL I WANT TO DO is to construct a formula to be located in, say cell
H10, which would contain a running column total of all cells in column
C starting from a point partway down column C and continuing
indefinitely. For example, say I've got values in C2:C21 but DO NOT
WANT THOSE CELLS INCLUDED in the running total, I just need the sum
from cells C22 downward. Believe it or not I've spent an hour trying
to figure this and all I ever see under the subject of running column
totals assumes that your total begins at the top of the worksheet, in
row 2. In fact, in John Walkenbach's "Excel 2002 Formulas," when
talking about 'Computing a Cumulative Sum' he states "The first cell
in the range reference ALWAYS REFERS TO ROW 2" (p. 203, emphasis
added).
So I'm wondering: Does this simple problem highlight a weakness in
Excel 2002?

Thanks for your time & attention to detail ;-}

Terry.
 
Terry,

DO you mean

=SUM(C22:C1000)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
I'm not sure what you mean by a "running total" with only one cell
to sum in. To sum a "column total of all cells in column C"
excluding cells C1:C21:

H10: =SUM(C22:C65536)

If you want a "running" total where H10 sums C22, H11 sums C22:C23,
H12 sums C22:C24, etc, enter:

H10: =SUM(C$22:C22)

and copy down.
 
Thanks for the replies ;-} Yes, what I meant to ask for was the
formula for a "column total of column C from cell C:22
and-down-as-far-as the last entry, where the column will be added to
periodically, and I want the result to appear in cell H10."
And I realize that both the answers suggested (=SUM(C22:C1000) [and]
=SUM(C22:C65536) WOULD WORK JUST FINE---I just thought there was a
more-shorthand way of expressing 'as far down column C as the most
recent entry'--maybe "C22:C..." or something easier to write (?)
At any rate, thanks for your time.
Terry.
 
Back
Top