To take my new BSP go-fast car to the alingment shop for a tad more of
toe-in in the rear.
James Creasy wrote:
> if its for his garage sale, im guessing he means he sells 5 items at $50
> each, and wants to "add up" how much that is. but it makes me think
> multiply is easier.
>
> barry? are you still listening? :)
>
> and why are you up so early? im going to the autolites today at sears.
>
> james
> OSP - Omnipotent Snake Prevails
>
> ----- Original Message -----
> From: "Kenneth Allan Mitchell" <nokones@kenmitchell.com>
> To: "James Creasy" <james@thevenom.net>
> Cc: "Barry Spencer" <bspencer@tsoft.com>; "Autox" <ba-autox@autox.team.net>
> Sent: Saturday, August 02, 2003 7:04 AM
> Subject: Re: Help with excel please
>
>
>
>> 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
>>
>>
>
>
>
--
Kenneth Allan Mitchell
mailto:nokones@kenmitchell.com
|