No, they are very different in the MS concept.

SUMIFS allows the summation of a range dependent upon multiple conditional
tests on ranges.

SUMPRODUCT multiples tow or more arrays and sums the results.

Of course, SUMPRODUCT has been (ab)used by spreadsheet developers to
incorporate conditional tests (something MS seem largely oblivious to), in a
manner similar to the old familiar SUMIF, but even more similar to the new
Excel 2007 COUNTIFS and SUMIFS. But COUNTIFS and SUMIFS does not supersede
SUMPRODUCT because SUMPRODUCT is so much more versatile than COUNTIFS and
SUMIFS (and thereby than COUNTIF and SUMIF), it allows the inclusion of
extra functions to be acted upon the ranges being tested or counted or
summed. Here is a relatively complex example which calculates how many dates
in a range have a week number of 20

=SUMPRODUCT(--(1+INT(($A$2:$A$200-(DATE(YEAR($A$2:$A$200),1,2)
-WEEKDAY(DATE(YEAR($A$2:$A$200),1,1))))/7)=20),B$2:B$200)

this is not possible with SUMIF, and so cannot be done with SUMIFS, but as
you see can be done with SUMPRODUCT.

Of course, these modified conditions could be added to separate columns and
COUNTIFS and SUMIFS act upon these columns, which might actually be more
efficient, but that is another question.

--
__________________________________
HTH

Bob

"wx4usa" wrote in message
...
Not familiar with SUMIFS in 2007. Are SUMIFS and SUMPRODUCT the same?

If not what is the difference? Thanks