adding values in a column

I want to add currency values in column A and in column B, each time I add a
new value, column B updates with the total. However, I don't want the last
sum to be displayed down the entire column B. How can I hide that?

Charley
Tue Apr 26 22:16:48 CDT 2005

Does this illustrate what you want?...

Suppose you have data in column A, in the range A3:A8. In the range B3:B100
you have the running total for column A. (Cell B8, for example, has the
formula =B7+A8.) But no subtotals show above or below cell B8. Then, when
you enter a value in cell A9, the subtotal appears only for cell B9.

If that's what you want, here's how to do it:

Select the range B3:B100. Make sure that cell B3 is the active cell. Choose
Format, Conditional Formatting. For Condition 1, choose Formula Is in the
list box. In the single text box, enter this formula:

=OR(B3="",B4<>"")

Choose Format... In the Font tab, specify a white font. Then choose OK
twice.

With luck, all the results in column B will disappear except cell B8, which
is the subtotal for the last-entered value in cell A8.

Charley Kyd
ExcelUser.com

"§" <sensaissub@yahoo.com> wrote in message
news:sHCbe.14721$An2.513@newsread2.news.pas.earthlink.net...
>I want to add currency values in column A and in column B, each time I add
>a
> new value, column B updates with the total. However, I don't want the
> last
> sum to be displayed down the entire column B. How can I hide that?
>
>
>

RagDyeR
Wed Apr 27 04:57:48 CDT 2005

If zeroes down the column are acceptable, try:

=SUM($A$1:A1)*(A1<>"")

If blank cells only are required, try:

=IF(A1,SUM($A$1:A1),"")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"§" <sensaissub@yahoo.com> wrote in message
news:sHCbe.14721$An2.513@newsread2.news.pas.earthlink.net...
I want to add currency values in column A and in column B, each time I add a
new value, column B updates with the total. However, I don't want the last
sum to be displayed down the entire column B. How can I hide that?

§
Wed Apr 27 20:08:36 CDT 2005

Perfect! Thank you so much!!!

"Charley Kyd" <kyd at incsight dot com> wrote in message
news:eKnfQetSFHA.3464@tk2msftngp13.phx.gbl...
> Does this illustrate what you want?...
>
> Suppose you have data in column A, in the range A3:A8. In the range
> B3:B100 you have the running total for column A. (Cell B8, for example,
> has the formula =B7+A8.) But no subtotals show above or below cell B8.
> Then, when you enter a value in cell A9, the subtotal appears only for
> cell B9.
>
> If that's what you want, here's how to do it:
>
> Select the range B3:B100. Make sure that cell B3 is the active cell.
> Choose Format, Conditional Formatting. For Condition 1, choose Formula Is
> in the list box. In the single text box, enter this formula:
>
> =OR(B3="",B4<>"")
>
> Choose Format... In the Font tab, specify a white font. Then choose OK
> twice.
>
> With luck, all the results in column B will disappear except cell B8,
> which is the subtotal for the last-entered value in cell A8.
>
> Charley Kyd
> ExcelUser.com