so =sumif() IS available in 2000?

if so, in your formula, you use "selection" is that an actual named range in your workbook? if you dont have a range created with that name, that many be causing the error