How to sum a specific # of cells

[Varnstuf21]

If I had a weekly chart of how much is payed on a weekly basis how can I sum them up based on the number of week it is...

Example:

Week# 1-2-3-4-5-6-7-8-9-10
Amount- 6-6-5-5-5-6-6-5-6-5

How can I have a cell that I just enter in the week# and it totals how much i've spent total to that week. Example if I entered 5 in the cell I want it to total up weeks 1-5 which would be $27 spent. If I entered in 10 it would return 55.

PLEASE HELP! thanks!

 

[VoG]

This very similar thread may help you http://www.mrexcel.com/forum/showthread.php?t=565074

 

[Varnstuf21]

Thanks buddy.... that link worked great!

 

[abmati]

You can try like this:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	Week#	1	2	3	4	5	6	7	8	9	10
2	Amount	6	6	5	5	5	6	6	5	6	5
3	INPUT	5
4	OUTPUT	27	Sum amount for Week# 1 to 5
5
Sheet1

Regards,