What are you trying to do with

IF(OC!I3:I9999<OC!Date(2007,6,6),0)

If you're looking for date, loose the 'OC' prefix. DATE isn't a cell
reference.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


wrote in message
ps.com...
I wrote the following conditional Sum:

=SUM(IF(OC!B3:B9999=Overview!E26,IF(OC!I3:I9999OC !
Date(2007,1,1),IF(OC!I3:I9999<OC!Date(2007,6,6),0) ,0))

Basically, range B3:B9999 has to equate to cell OverviewE26, and the
date has to be between Jan1/07 and Jun 6/06

For some reason the formula keeps erroring out on the statement: IF(OC!
I3:I9999

Any ideas? Thanks!