SUMIF not working?

[sa02000]

I have a column with dates and text values in it. I am trying to use sumif to count the cells that have dates in it but for some reason its not counting all the dates.

=COUNTIF('2007_Deals'!$D$3:$D$119,"<=TODAY()")

I tried the following formula (and the copied down) in separate column and I get "yes" for all the cells that have dates in it.

=IF(D11<=TODAY(),"yes","no")

My cells that have text in it are also formated as date so I can't use text within sumif. And I don't want to go to each cell and change the format for the cells that are not dates.

Thank you,
Jay

[Norie]

Jay

That isn't comparing the dates to today's date it's comparing them to the text string "<=TODAY()".

Try this.

=COUNTIF('2007_Deals'!$D$3:$D$119,"<="&TODAY())

[Badger101]

=COUNTIF('2007_Deals'!D1:D18,"<="&TODAY())

[sa02000]

Works perfectly now. Thank you for quick replies.

Jay