Running total as I add lines

[Veronica Johnson]

Hi,

Column K is Amount
Column L is GP (Gross Profit).
Columns A through J include my qty, vdr name, vdr #, vdr price, etc

As I add additional vendors and information, I want Excel to keep
running totals in columns K and L. However, is it possible for these
"running total" lines to continue moving downward as I enter
information in A through J?

For instance, I have my SUM function in columns K and L right now,
however, when I go to print it, it prints 2 pages because the SUM is
all the way at the bottom of the page, along with all the $0.00
cells(where no information is entered yet). I want the SUM to be just
below the last Amount and GP I enter.

Any way to do this?

 

[Dan R.]

Use something like this:

=IF(AND(A1<>"",C1<>""),SUM(A1,C1),"")

 

[Don Guillett]

Perhaps, put the sum at the top

 

[Pete_UK]

I think you will find it easier to put your SUM formula at the top of
your sheet - insert a new row above your headings, then something
like:

=SUM(K3:K3000)

in cell K1. Adjust this range if you expect more than 3000 rows of
data.

Select cell A3, then Window | Freeze Panes to ensure that the top two
rows are always visible.

Hope this helps.

Pete