I'm struggling to see why it won't work to be honest, and am wondering if it
means that there is perhaps another error in your formula somewhere. If you
try the section of the formula that I outlined on it's own, you should see
that it works in isolation, so there is little reason to believe it won't
work as part of another formula. The SUMPRODUCT formula also works fine in
isolation, so same again.

Have you tried breaking the formula down and testing each of the elements
individually, or perhaps using Tools / Formula Auditing / Evaluate to see
which parts of the formula don't evaluate correctly?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
<snip