MTD Formula help!

R

Ray

I'm trying to set-up a spreadsheet which contains seven
columns

A) Date
B) # of Invoices Generated
C) Daily Sales
D) Average dollars per Invoice
E) MTD # of Invoices
F) MTD Sales
G) MTD Average Invoice

My question: What formula can I use for columns E F & G ?
I want to run MTD totals. Not sure how to accomplish this
task with out populating all the days with the last total
i.e. if it's the 15th the 16th through the 30th cells are
populated with the same total.
Please Help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Specify MTD Diff by month's columns 0
Specify columns to add for months MTD Diff 3
specify which month's columns to use in mtd calculation 0
MTD Formula Help! 1
error trying to sort data 4
Specify a column by the month to calculate it's data 6
if function (if more that 7 nesting) 2
Auto Change Formulas - Please Help. 2

Top