adding values in a column

  • Thread starter Thread starter §
  • Start date Start date
§

§

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?
 
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
 
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!
==============================================


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?
 
Back
Top