The easiest way is to just pick a row number that you never think you'll exceed, e.g. A2:A20000 and B2:B20000. I believe in Excel 2007+ you can reference whole columns in SUMPRODUCT formulas (in Excel 2003- you can't), but be advised that this could greatly impact performance.