Thread: Sumif criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Louis Zaffino Louis Zaffino is offline
external usenet poster
 
Posts: 1
Default Sumif criteria

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?