software

Hi

What I want to do is add a2 to b1 and have the total show in b2.
I also want it set up so that when a number is entered in the a column
it is automaticaly added to the previous b colum cell and then totaled
across from that a cell.
thank you for your help -------------------------------------------------------------------
|Filename: excel test 1.doc |
|Download: www.excelforum.com/attachment.php?postid=4445 |
-------------------------------------------------------------------

--
catnohat
------------------------------------------------------------------------
catnohat's Profile: www.excelforum.com/member.php...oamp;userid=32377
View this thread: www.excelforum.com/showthread...hreadid=521394Type the following in cell b2

= sum(a:a) b1--
HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758quot;catnohatquot; wrote:

gt;
gt; Hi
gt;
gt; What I want to do is add a2 to b1 and have the total show in b2.
gt; I also want it set up so that when a number is entered in the a column
gt; it is automaticaly added to the previous b colum cell and then totaled
gt; across from that a cell.
gt; thank you for your help
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: excel test 1.doc |
gt; |Download: www.excelforum.com/attachment.php?postid=4445 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; catnohat
gt; ------------------------------------------------------------------------
gt; catnohat's Profile: www.excelforum.com/member.php...oamp;userid=32377
gt; View this thread: www.excelforum.com/showthread...hreadid=521394
gt;
gt;

Hi!

Enter this formula in B2 and copy down as needed:

=IF(A2=quot;quot;,quot;quot;,SUM(B$1,A$2:A2))

Biff

quot;catnohatquot; gt; wrote in
message ...
gt;
gt; Hi
gt;
gt; What I want to do is add a2 to b1 and have the total show in b2.
gt; I also want it set up so that when a number is entered in the a column
gt; it is automaticaly added to the previous b colum cell and then totaled
gt; across from that a cell.
gt; thank you for your help
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: excel test 1.doc |
gt; |Download: www.excelforum.com/attachment.php?postid=4445 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; catnohat
gt; ------------------------------------------------------------------------
gt; catnohat's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32377
gt; View this thread: www.excelforum.com/showthread...hreadid=521394
gt;

I appreciate the effort galami, but when I put a figure in the a colum
it still will not automaticaly add to the previous b column cell and
then show the concurrent total. I hope someone can help me.

Thanks to everyone for trying!!--
catnohat
------------------------------------------------------------------------
catnohat's Profile: www.excelforum.com/member.php...oamp;userid=32377
View this thread: www.excelforum.com/showthread...hreadid=521394
Thanks, but that formula still isn't quite what I'm looking for. I have
included an attachment of an excel snippet with an explanation, perhaps
this will clearify my question. I want to thank you and everyone for
your help. -------------------------------------------------------------------
|Filename: excel example 2.doc |
|Download: www.excelforum.com/attachment.php?postid=4446 |
-------------------------------------------------------------------

--
catnohat
------------------------------------------------------------------------
catnohat's Profile: www.excelforum.com/member.php...oamp;userid=32377
View this thread: www.excelforum.com/showthread...hreadid=521394Hi!

My formula does exactly what you're asking for.

When you say:

gt;that formula still isn't quite what I'm looking for.

I may not know what you're looking for but it does exactly what you've asked
for.

Based on your sample 2 doc the result in cell B3 should be 74 and that's
what my formula will give you.

We must be missing something in translation!

Biff

quot;catnohatquot; gt; wrote in
message ...
gt;
gt; Thanks, but that formula still isn't quite what I'm looking for. I have
gt; included an attachment of an excel snippet with an explanation, perhaps
gt; this will clearify my question. I want to thank you and everyone for
gt; your help.
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: excel example 2.doc |
gt; |Download: www.excelforum.com/attachment.php?postid=4446 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; catnohat
gt; ------------------------------------------------------------------------
gt; catnohat's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32377
gt; View this thread: www.excelforum.com/showthread...hreadid=521394
gt;
that certainly would not be very efficient. In fact it wouldn't even be correct.

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;galimiquot; gt; wrote in message ...
gt; Type the following in cell b2
gt;
gt; = sum(a:a) b1
gt;
gt;
gt; --
gt; HelpExcel.com
gt; 1-888-INGENIO
gt; 1-888-464-3646
gt; x0197758
gt;
gt;
gt; quot;catnohatquot; wrote:
gt;
gt; gt;
gt; gt; Hi
gt; gt;
gt; gt; What I want to do is add a2 to b1 and have the total show in b2.
gt; gt; I also want it set up so that when a number is entered in the a column
gt; gt; it is automaticaly added to the previous b colum cell and then totaled
gt; gt; across from that a cell.
gt; gt; thank you for your help
gt; gt;
gt; gt;
gt; gt; -------------------------------------------------------------------
gt; gt; |Filename: excel test 1.doc |
gt; gt; |Download: www.excelforum.com/attachment.php?postid=4445 |
gt; gt; -------------------------------------------------------------------
gt; gt;
gt; gt; --
gt; gt; catnohat
gt; gt; ------------------------------------------------------------------------
gt; gt; catnohat's Profile: www.excelforum.com/member.php...oamp;userid=32377
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=521394
gt; gt;
gt; gt;
Actually I think he was looking for something to be automatically filled in,
and for that you need an event macro,

or try to rely on quot;Extend lists and formatsquot; which has so many twists and turns
that it usually doesn't work out. Though in this case it might.

I would use the following in B2 and extend it down as needed or use
an event macro to extend.
B2: =A2 OFFSET(B2,-1,0) instead of =A2 B1
the reason is so that you can easily insert or delete rows and
extend the formulas manually easily without having to modify formulas.

This is described on
www.mvps.org/dmcritchie/excel/insrtrow.htm
www.mvps.org/dmcritchie/excel/offset.htm

An Example of an Event macro to extend formula
Change Event (#change_event)
www.mvps.org/dmcritchie/excel...m#change_eventBiff's formula works
B2: =IF(A2=quot;quot;,quot;quot;,SUM(B$1,A$2:A2))
but it is not efficient because it adding up all of column A down to the
current row for each total rather than making use of a previous sum
in the row above. The check for A2=quot;quot; allows you extend the formula
down past what you need without showing, but it will extend the used range
and require printing. Not efficient would not be noticed until you have
several thousand rows or a workbook full of such formulas.
groups.google.com/groups?as_u...2@TK2MSFTNGP10

At first I thought the original poster was seeing only galimi's reply because
ExcelForum does not thread but just attaches to the last reply in a newsgroup
thread (a minor problem compared to the more serious problems it causes), but there
were two separate replies from the original poster so he did refer to both replies,
I just think it was not understood that he would have to extend the formula from Biff down
and that an empty cell or null in column A would result in an empty column B but that
totals would still continue if more values are filled in column A later (say down two cells)..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Biffquot; gt; wrote in message ...
gt; Hi!
gt;
gt; My formula does exactly what you're asking for.
gt;
gt; When you say:
gt;
gt; gt;that formula still isn't quite what I'm looking for.
gt;
gt; I may not know what you're looking for but it does exactly what you've asked
gt; for.
gt;
gt; Based on your sample 2 doc the result in cell B3 should be 74 and that's
gt; what my formula will give you.
gt;
gt; We must be missing something in translation!
gt;
gt; Biff
gt;
gt; quot;catnohatquot; gt; wrote in
gt; message ...
gt; gt;
gt; gt; Thanks, but that formula still isn't quite what I'm looking for. I have
gt; gt; included an attachment of an excel snippet with an explanation, perhaps
gt; gt; this will clearify my question. I want to thank you and everyone for
gt; gt; your help.
gt; gt;
gt; gt;
gt; gt; -------------------------------------------------------------------
gt; gt; |Filename: excel example 2.doc |
gt; gt; |Download: www.excelforum.com/attachment.php?postid=4446 |
gt; gt; -------------------------------------------------------------------
gt; gt;
gt; gt; --
gt; gt; catnohat
gt; gt; ------------------------------------------------------------------------
gt; gt; catnohat's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=32377
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=521394
gt; gt;
gt;
gt;