Sum If and Count If
 

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,D3:D51). I have also tried converting
column A to show 2009 instead of 09, but I still get 0 as the result for both.

Sum If and Count If
 

Hi TB,

Try:

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

HTH,

Wouter

Sum If and Count If
 

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

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