Re: Help with excel please

["James Creasy" <james@thevenom.net>]

1. multiply qty times $$ and create a new column for this.  the equation
would be like =B1*C1
2. use the "fill down" feature by selecting the cells in this new column,
and pressing Ctrl-D , or select Fill->Down from the menu. this creates a
column of the subtotals.
3. create the grand total by a cell where you want the grand total to go,
type

    =SUM(

then select all the cells you want to add up (all the cells in your new sub
total column). excel completes the sum equation.

presto!

james
OSP - Obviously Spreadsheet Pros


----- Original Message -----
From: "Barry Spencer" <bspencer@tsoft.com>
To: "Autox" <ba-autox@autox.team.net>
Sent: Friday, August 01, 2003 11:11 PM
Subject: Help with excel please


> If you have a qty in column B and a $$ in column C, how do you add that up
to
> go into column D ???
>
> Thanks
>
> Barry
>
> PS trying to get a spread sheet setup for the gargage sale :>))