then you have to use sumproduct.

sumifs don't exist in the excel 2003 version.