Running total as I add lines

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Veronica Johnson - 21 Dec 2007 15:00 GMT

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?

Reply to this Message

Dan R. - 21 Dec 2007 15:28 GMT

Use something like this:

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

--
Dan

> Hi,
>
[quoted text clipped - 14 lines]
>
> Any way to do this?

Reply to this Message

Don Guillett - 21 Dec 2007 15:38 GMT

Perhaps, put the sum at the top

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Hi,
>
[quoted text clipped - 14 lines]
>
> Any way to do this?

Reply to this Message

Pete_UK - 21 Dec 2007 16:02 GMT

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

> Hi,
>
[quoted text clipped - 14 lines]
>
> Any way to do this?

Reply to this Message