SUM a dynamic range

[SHOOTme]

I'm new at this excel stuff.
My eyes are laying on my keyboard for having watched umteen "How To Videos" yet I still can't figure this out. ...just shoot me! I'm a DBA so my thought processes, well, is a bit different...

How do you SUM a dynamic range???
This is simple, right??

Heres my worksheet:
An invoice shows items sold: 1 thru 15 items (dynamic) and each price.
A SUM totaling (is that a word?) the prices of all items purchased.

The layout is typical:

Dog Food $3.00
Cat Food $1.00

Total $4.00

If I only offer 15 items for sale, yet a customer can purchase as few as 1 item, how do I total the dynamic range of prices for Items purchased?

 

[Trevor G]

Hi and welcome to the forum.

Structure your spreadsheet so you have different columns, how many and a cost per item, then a total column multiplying the other 2

As other items are being added to the order you should then get a running total, if you add a sum of the last column a little further down the sheet, example as below:

Excel Workbook
	B	C	D	E
2		Tins	Cost Per Tin	Total
3	Dog food	3	0.75	2.25
4	Cat Food	1	0.56	0.56
5	Another Tin	23	1.2	27.6
6
7
8
9
10
11	Total food			30.41
Sheet2

ANother view with the formula shown

Excel Workbook
	B	C	D	E
2		Tins	Cost Per Tin	Total
3	Dog food	3	0.75	=D3*C3
4	Cat Food	1	0.56	=D4*C4
5	Another Tin	23	1.2	=D5*C5
6
7
8
9
10
11	Total food			=SUM(E3:E10)
Sheet2