excel

N

Norman Harker

Hi "ùàåì"

It might help explain precisely what you mean. Also it is best to be a
little more explicit in your subject line as all questions on these
Excel groups relate to Excel.

For further assistance in use of these newsgroups see:

Chip Pearson:
http://www.cpearson.com/excel/newposte.htm

Dave McRitchie
http://www.mvps.org/dmcritchie/excel/posting.htm

Both have links to their topics pages at the bottom which you will
also find helpful in covering a wide range of standard and not so
standard questions.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Public Holidays Monday: Central African Republic (National Day of
Prayer); El Salvador (Balance Day); Guatemala (Army Day); Israel (Rosh
Hodesh Tammuz); Sudan (National Salvation Revolution Day); Ukraine
(Constitution Day); Zaire (Independence Day).
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Ù

ùàåì

Hi,
Can you help me how to create an accumulation cell in a worksheet??
Thank you
 
D

David McRitchie

You can use the SUM button (Sigma, Greek Letter)
say you have values to be totaled from D2:D27
with the sum to be placed into D28
Select D2:D27 and press the SUM button
which would generate =SUM(D2:D27) into cell D28.

The SUM button is designed to work in various situations,
but may not always figure out what you wanted.
If D27 is empty and last row is 26 then
D27 will receive the Total; otherwise, probably D28.

If you want to create a Sum that adjusts better should you
need to insert a row above your total later on would use
something like
D28: =SUM(D$2:OFFSET(D28,-1,0)
which can be read as the D2 (row does not change) through
the cell above D28. As =SUM(D2:D28)

More on the use of OFFSET and why using OFFSET is better
see my Insert Row page
Insert a Row using a Macro to maintain formulas
OFFSET Worksheet Function (#offset)
http://www.mvps.org/dmcritchie/excel/insrtrow.htm#offset

Please use descriptive subject names so people looking through
archives for answers have a better idea what the subject actually is.
Your subject in your own words might better be identified as
"Accumulation Cells"i
 
H

Harlan Grove

So where's your pertinent contribution? Up to your old
tricks are ya?
Click to expand...

When did I ever stop?

Not relevant contribution on this thread, but at least I
of the two of us has some relevant contribution in the
Google Groups archives.

http://www.google.com/groups?selm=axyf9.23229%
24jG2.1662648%40bgtnsc05-news.ops.worldnet.att.net

Didn't see the need to add anything since there were two
out of three useful initial responses.
 
H

Harlan Grove

Me said:
Looks like 3 to me.
Click to expand...

OK, we differ on whether Norman's response was useful. It's obvious, though,
that he was the 1 out of 3 who didn't understand what 'accumulator' means in
standard programming terminology.
 
Top