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
|