Hi there.

I have an array formula (Sum(IF((...)) that I would like to include a date
value in. For example, Sum(If(($C$1:C$1000=1/3/2005),$B$1:$B$1000,0)).

For some reason that I can't figure out, it seems to work when I do this
directly in the worksheet but will not work when I try to create the formula
in VBA.

Is there some special way of handling a date value?

Thanks,
CaroKannDefence