formulas needed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to make a spead sheet : in this sheet how can I fourmulate a given quanity times a given dollar amount (in a row) and then the total dollar amount (all rows). example: 25 cans 22.00each =????auto
05 cans 2.00each =????auto
21cans 21.00each =????auto
20 cans 22.00each =????auto
=????auto
I hope I explained it enough and not too much. need help fast
 
Assuming you have something set-up along the lines below
in cols A to C, data in row2 down:

Order_UnitPrice_TotalCost
__5_____2________??
etc

where Order and UnitPrice
in cols A and B are inputs (numbers),
TotalCost in col C is auto-calculated

Put in C2: =A2*B2
Format C2 as currency
Copy C2 down as many rows as you have data

Put in say, D1: =SUM(C2:C100)
D1 will give the grand total of col C
(adjust the range C2:C100 to suit)

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----
blue said:
I am trying to make a spead sheet : in this sheet how can I fourmulate a
Click to expand...
given quanity times a given dollar amount (in a row) and then the total
dollar amount (all rows). example: 25 cans 22.00each =????auto
 
G'day Blue!

As long as you're not mixing the numbers and text in one entry:

=A1*B1

Total will be =SUM(C1:C3)

If this is not a recent request for you, look at your maxim <vbg>
 
Back
Top