Sum If and Count If

[TB@work]

Is there a way to use sumif and count if if your criteria is dates? In my
spredsheet column A are dates. My spreadsheet looks like this.

A B C D
Date Loc. Stops $
11/17/09 Miami 2 $1150
11/18/09 Orlando 1 $1000

I have tried =SUMIF(A3:A5,11/17/9,D351). I have also tried converting
column A to show 2009 instead of 09, but I still get 0 as the result for both.

 

[RadarEye]

Hi TB,

Try:

=SUMIF(A3:A5;Date(2009;11;17);D35)

HTH,

Wouter

 

[RadarEye]

Sorry, I have a different International setting.
Ik should be:

=SUMIF(A3:A5, DATE(2009, 11, 17), D35)