sum of dates

  • Thread starter Thread starter debtless
  • Start date Start date
D

debtless

I have a list of sales with dates, like 23-Mar-00. I would like to add
up how many sales were made in the year 2001. I know this is probably
very easy but I am new at this. Thanks for your help.

Brent
 
I have a list of sales with dates, like 23-Mar-00. I would like to add
up how many sales were made in the year 2001. I know this is probably
very easy but I am new at this. Thanks for your help.

Brent
Click to expand...

Let us say that your dates are in A2:A1000, and the corresponding sales are in
column B.

=SUMIF(A2:A1000,">="&DATE(2001,1,1),B2:B1000) -
SUMIF(A2:A1000,">"&DATE(2001,12,31),B2:B1000)


--ron
 
Back
Top