Use this instead...
"<"&A3
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
"Louis Zaffino"
wrote in message
In the criteria section of the Sumif formula if I reference a date (ex.
"<A3") I do not get the correct answer but if I in put the serial number of
that date (ex."<39251") I do get the correct response. Why is this?