Can "SUMIF's" criteria handle dates?

[FMedina_IL]

Column A has a long list of dates, not necessarily in sequential order.
Column B has amounts ($$ or sale counts or whatever)

How can I use Sumif where I select in the criteria a date range lik
greater or equal to 1/1/2003 AND less or equal to 12/31/2003?

For eample: =SUMIF(A:A,">=1/1/2003" AND "<=12/31/2003,B:B)

I can't make it work. I even used Julian dates to no avail!

Thanks for your insight!

Fernando
MS Excel 2002 SP2[B

 

[Frank Kabel]

Hi
try
=SUMPRODUCT((A1:A1000>=DATE(2003,1,1))*(A1:A1000<=DATE(2003,12,31)),B1:
B1000)

or
=SUMPRODUCT(--(YEAR(A1:A1000)=2003),B1:B1000)

 

[Peo Sjoblom]

Try

=SUMIF(A:A,">="&DATE(2003,1,1),B:B)-SUMIF(A:A,">"&DATE(2003,12,31),B:B)

or

=SUMPRODUCT(--(YEAR(A1:A65535)=2003),B1:B65535)

 

[FMedina_IL]

Thanks Peo. I'll try this tomorrow, as well as other postings' ideas.
Fernand

 

[FMedina_IL]

Frank, thanks a lot. You posting and others will help me a lot.
Fernand