Sum If and Count If

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,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.
 
R

RadarEye

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top