Note that with Sumproduct it is not recommended to use whole column references... for efficiency sake.... it will be processing cells needlessly....