Calculate Month-to-Date Sales

[Jay Foy]

A daily Sales worksheet contains Daily sales in F4 and Month-to-Date sales in G4. Example; on 8-3-2007 Daily sales in F4 contains $50 and Month-to-Date sales in G4 contains $135 which is the Sum of sales for 8-1-2007 + 8-2-2007. Is there a formula that can be used in G4 that will automatically calculate Month-to-Date sales?
Regards
Jay

 

[Datsmart]

Any formula would also need to reference a date column somewhere.
Does your worksheet contain any dates?

 

[Datsmart]

Guessing at your data layout.
Hope this helps.

Excel Workbook
	A	B	C	D	E	F	G
1	Date	Sales
2	08/01/07	$10.00
3	08/02/07	$11.00				Daily	MTD
4	08/03/07	$12.00				$16.00	$91.00
5	08/04/07	$13.00
6	08/05/07	$14.00
7	08/06/07	$15.00
8	08/07/07	$16.00
9	08/08/07	$17.00
Sheet