Hi All,

Here's another I hope you can help with.

Here's my formula that works fine:

{=SUMPRODUCT(--($B$6:$B$417<DATE(2009,10,1)),--($Q$6:$Q$417=B463),$D
$6:$D$417)}

Now I want to change the end to ,$D$6:$O$417)}, but changing the D to
an O gives the old #VALUE!.

I don't suspect the cells in the formula because I'm using them with
other similar formulas.

Any help would be appreciated.

Thanks,

Michele