You didn't want to try it before you asked? Yes SUMIF can use the whole range,
since your formula isn't in the same workbook as the one you are getting
information from, remember that both workbooks need to be open


Regards,

Peo Sjoblom

"Erika" wrote:

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)