is one preferable to the other, since i can use either and get the
same result?
thanks

Sumif can test for only one condition, but Sumproduct can test multiple
conditions [ see http://www.xldynamic.com/source/xld.SUMPRODUCT.html ]. So
if you're testing only one condition, use Sumif.