Unless you have XL2007, you cannot use an entire row as a range for
Sumproduct. You must use a specific range. So if your paste somehow "gets
rid of the A1 and IV1", then put it back. If your range ends at DD1, then
use:

Apparently you can... for rows. This works fine in my XL2003...

=SUMPRODUCT(--(YEAR(1:2)=YEAR(NOW())))

where I modified the formula to look at rows 1 and 2. And Excel did change
the A1:IV1 range to 1:1 automatically.

Rick