# Calculate Month-to-Date Sales

#### Jay Foy

##### New Member
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

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

#### Datsmart

##### Well-known Member
Any formula would also need to reference a date column somewhere.
Does your worksheet contain any dates?

#### Datsmart

##### Well-known Member
Hope this helps.
Excel Workbook
ABCDEFG
1DateSales
208/01/07\$10.00
308/02/07\$11.00DailyMTD
408/03/07\$12.00\$16.00\$91.00
508/04/07\$13.00
608/05/07\$14.00
708/06/07\$15.00
808/07/07\$16.00
908/08/07\$17.00
Sheet

Replies
4
Views
95
Replies
9
Views
97
Replies
6
Views
86
Replies
3
Views
144
Replies
15
Views
159

1,191,204
Messages
5,985,263
Members
439,953
Latest member
suchitha

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back