Try using Dynamic Ranges

(Entire columns won't work for Sumproduct in pre 2007 versions)