MTD Formula Help!

[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 D-E & F ?
I want to run MTD totals. Not sure how to accomplish this
task with out populating all the dates with the last total
i.e. if it's the 15th the 16th through the 30th are the
same total. Please Help!

 

[Debra Dalgleish]

You can check for an entry in the Sales column. For example in cell D2:

=IF(C2="","",C2/B2)

In E2: IF($C2="","",SUM(B$2:B2))