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
Regards
Jay