Didn't Barry say "add" and not multiply? Maybe I'll go back to sleep
and wake up and see if it says multiply.
James Creasy wrote:
> 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 :>))
>
>
--
Kenneth Allan Mitchell
mailto:nokones@kenmitchell.com
|