jw01 - if i understand you correctly, then:

XL2003 = SUMPRODUCT
XL2007 = COUNTIFS