Automatically Calculate the New Balance

[Tony D]

I am trying to calculate the new balance in Excel 2010 automatically. In the attachment I want to have columns B through G calculated with the result shown in column H automatically.

[Special-K]

This is a text attachment, not an Excel attachment.
You havent stated what the formulas are for B through G.

[Tony D]

I did not know how to attach directly from Excel 2010. That is why I used notepad to input the example. Now, I think I know how to do it. If you note on line 12 (in green)I have a sample line input from column A - G. What I want to do is calculate B12 thru G12 automatically without clicking on AutoSum for every line input and have the result in column H. I know it can be done as when I had Excel 2007 I was able to do it but I forgot how to do. I called Microsoft Tech Support many times but I either get the call center in India or Phillipines, which I am not able to understand their english. I contacted Microsoft about this but it seems it reaches deaf ears.


Tony

[robertswart]

It's not entirely clear what you want to do. Do you want to use =sum(B12:G12) ?

[FDibbins]

if what you are trying to do, is get an automatic total for column H, then try this in H8, copied down...i only used in on US Bank Sheet....

=IF(A8="","",H7+F8+G8)

let me know if this is what you need?

[FDibbins]

Tony, see if the attached gives you what you need? I have also added a formula to col B to make it easier too