T
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.
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.