Creating a formula that calculates a total cell

I have a spreadsheet that I use for an order guide. The spreadsheet contains
the 1st sheet which is for inventory and the next 6 sheets are the order
pages.
Each time I enter a # of pcs. on the order sheet it reduces the inventory
sheet #'s.
Heres the delima. I have set up a new column to pull over from the inventory
page and displays the price on each order sheet. I would like to set up a
formula that references the price , multiplies it by the # of pcs,and at a
new cell adds all the references from the entire column giving me a dollar
total. Any thoughts?

If Price in Column A and Qty in Column B then in Column C:

=A1*C1 and copy down

Order dollar total =SUM(C1:C10) for 10 order lines

Any taxes to be added?

Is this this what you want?

"Growers" wrote:

> I have a spreadsheet that I use for an order guide. The spreadsheet contains
> the 1st sheet which is for inventory and the next 6 sheets are the order
> pages.
> Each time I enter a # of pcs. on the order sheet it reduces the inventory
> sheet #'s.
> Heres the delima. I have set up a new column to pull over from the inventory
> page and displays the price on each order sheet. I would like to set up a
> formula that references the price , multiplies it by the # of pcs,and at a
> new cell adds all the references from the entire column giving me a dollar
> total. Any thoughts?

ok so I would like to connect both of those formula's
here's a sample
Quantity
Item Cost Client Name
day need tues
basil $5.00 3
bananas $25.00 1
beets $32.00
carrots $10.00 1
corn $20.00 2
cucumbers $30.00 1

$120
does this make any sense?


"Toppers" wrote:

> If Price in Column A and Qty in Column B then in Column C:
>
> =A1*C1 and copy down
>
> Order dollar total =SUM(C1:C10) for 10 order lines
>
> Any taxes to be added?
>
> Is this this what you want?
>
> "Growers" wrote:
>
> > I have a spreadsheet that I use for an order guide. The spreadsheet contains
> > the 1st sheet which is for inventory and the next 6 sheets are the order
> > pages.
> > Each time I enter a # of pcs. on the order sheet it reduces the inventory
> > sheet #'s.
> > Heres the delima. I have set up a new column to pull over from the inventory
> > page and displays the price on each order sheet. I would like to set up a
> > formula that references the price , multiplies it by the # of pcs,and at a
> > new cell adds all the references from the entire column giving me a dollar
> > total. Any thoughts?

So do I have to make a new column???

"Toppers" wrote:

> If Price in Column A and Qty in Column B then in Column C:
>
> =A1*C1 and copy down
>
> Order dollar total =SUM(C1:C10) for 10 order lines
>
> Any taxes to be added?
>
> Is this this what you want?
>
> "Growers" wrote:
>
> > I have a spreadsheet that I use for an order guide. The spreadsheet contains
> > the 1st sheet which is for inventory and the next 6 sheets are the order
> > pages.
> > Each time I enter a # of pcs. on the order sheet it reduces the inventory
> > sheet #'s.
> > Heres the delima. I have set up a new column to pull over from the inventory
> > page and displays the price on each order sheet. I would like to set up a
> > formula that references the price , multiplies it by the # of pcs,and at a
> > new cell adds all the references from the entire column giving me a dollar
> > total. Any thoughts?

In C1 enter =A1*B1

Double-click on the fill handle of C1 to copy down.

The total cell can be anywhere, say in D1

=SUM(C:C)


Gord Dibben MS Excel MVP

On Tue, 1 Aug 2006 13:34:02 -0700, Growers <[email protected]>
wrote:

>So do I have to make a new column???
>
>"Toppers" wrote:
>
>> If Price in Column A and Qty in Column B then in Column C:
>>
>> =A1*C1 and copy down
>>
>> Order dollar total =SUM(C1:C10) for 10 order lines
>>
>> Any taxes to be added?
>>
>> Is this this what you want?
>>
>> "Growers" wrote:
>>
>> > I have a spreadsheet that I use for an order guide. The spreadsheet contains
>> > the 1st sheet which is for inventory and the next 6 sheets are the order
>> > pages.
>> > Each time I enter a # of pcs. on the order sheet it reduces the inventory
>> > sheet #'s.
>> > Heres the delima. I have set up a new column to pull over from the inventory
>> > page and displays the price on each order sheet. I would like to set up a
>> > formula that references the price , multiplies it by the # of pcs,and at a
>> > new cell adds all the references from the entire column giving me a dollar
>> > total. Any thoughts?