Why does this function not work?
=IF(39752=Sheet2!D3=39722,Sheet2!A3,0)

You need to use an AND, eg:
=IF(and(Sheet2!D3=39722,Sheet2!D3<=39752),Sheet2! A3,0)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,500 Files:361 Subscribers:58
xdemechanik
---