Below is the formula I am using - is there a way to make the formula look at
$E:$E and $K:$K instead of defining a specific range?

=SUMIF('[2005 Totals.xls]2005 Sales'!$E$2:$E$38,"IM-natl",'[2005
Totals.xls]2005 Sales'!$K$2:$K$38)