SUMPRODUCT works with arrays but does not need to be array entered *unless*
you're using arguments that require array entry like IF or TRANSPOSE.

Biff

"dq" wrote in message
ps.com...
Ang,

Perhepas a stupid suggestion, but dit you enter the formula with Ctrl
+Shift+Enter ? SUMPRODUCT is an array formula and those always need to
be entered with Ctrl+Shift+Enter in stead of just Enter.

DQ