Ken and James, thanks for the replies. Carl and I talked off line late last
night and Carl was my hero.
Thanks again to all.
Barry
----- 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 8:02 AM
Subject: Re: Help with excel please
> 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
|