Try it like this...

Just a normal ENTER will do. No need to array enter.

=SUMPRODUCT(($B$6:$B$417<DATE(2009,10,1))*($Q$6:$Q $417=B463)*$D$6:$O$417)

Note that if there's any TEXT in the range $D$6:$O$417 you'll get an error.

--
Biff
Microsoft Excel MVP


"mjones" wrote in message
...
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