Thread: CountIF in R1C1 With Ampersand and Address Reference
View Single Post
 
Old 02-12-2012, 05:41 PM
zyzzyva57 zyzzyva57 is offline Windows 7 32bit Office 2007
Expert
  
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default
I think you may have a comma out of place

Here is what I tested with:

=COUNTIF(B1,"<"&TODAY()) = 1

I see with yours perhaps a comma in the wrong place

=COUNTIF(I24:I24,"<"&DP24)
Reply With Quote