Thank you very much for helping with criteria portion of the Sumif function.

"Jim Cone" wrote:

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?