Function Problem.
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!
|