Need help to find cumulative total

[tksrules]

Hi,
I am a begineer in excel.I know use of simple formulas like sum,etc.But i am stuck in a problem.The problem is:-
ON THE SAME WORKSHEET, COLUMN C (MONTH'S TARGETS) & COLUMN D ARE
(MONTH'S ACTUAL) SALES FIGURES.
I WANT COLUMN I (YTD TARGETS )& COLUMN j (YTD ACTUAL) ,TO BE A CUMMULATIVE YTD TOTAL.
EACH MONTH I WILL ENTER NEW DATA IN COLUMN C & D AND WANT THESE TO ADD AUTOMATICALLY TO COLUMN I & J , EQUALLING A YTD TOTAL.


Please explain the procedure to do so.I am a beginner.

 

[Sal Paradise]

Copy the formula across and down as you need:

Excel Workbook
	B	C	D	I	J
1		Targets	Actual	YTD Target	YTD Actual
2	Jan.	$13,816	$14,783	$13,816	$14,783
3	Feb.	$12,719	$11,956	$26,535	$26,739
4	Mar.	$10,600	$11,448	$37,135	$38,187
5	Apr.	$10,951	$11,170	$48,086	$49,357
6	May	$12,429	$11,435	$60,515	$60,792
7	Jun.	$11,970	$12,090	$72,485	$72,881
8	Jul.	$12,320	$13,552	$84,805	$86,433
9	Aug.	$11,021	$11,572	$95,826	$98,005
10	Sep.	$13,424	$13,558	$109,250	$111,564
11	Oct.	$13,168	$13,036	$122,418	$124,600
12	Nov.	$14,444	$13,577	$136,862	$138,177
13	Dec.	$11,639	$12,570	$148,501	$150,747
Sheet1

 

[tksrules]

Thats the matter.I dont want to copy down by dragging.
I want that to be automatic.As soon as i enter data new in first two columns cumulative averages in the last two columns should be automatically calculated.Is that possible?

 

[Sal Paradise]

If you have Excel 2003 (or better), you can make it a table, and those will be added automatically. Otherwise you need to use VBA.