software

I am trying to set up a spreadsheet to track daily, monthy and year to date
sales trends. How do I set up a formula to calculate the monthly to date and
year to date numbers if I enter new sales on a daily basis?

If your dates are in column A, and your sales are in column B, put this
formula in C1 and whatever quot;starting datequot;, be it first of the month, or
first of the quarter, or first of the year or whatever, in D1

=SUMIF(A1:A100,quot;gt;=quot;amp;D1,B1:B100)

Of course the cells and ranges can be adjusted to fit your circumstances.

Vaya con Dios,
Chuck, CABGx3
quot;RMAquot; wrote:

gt; I am trying to set up a spreadsheet to track daily, monthy and year to date
gt; sales trends. How do I set up a formula to calculate the monthly to date and
gt; year to date numbers if I enter new sales on a daily basis?