tracking daily and monthy sales

R

RMA

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?
 
C

CLR

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

=SUMIF(A1:A100,">="&D1,B1:B100)

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

Vaya con Dios,
Chuck, CABGx3
 
Top