Essentially, both ways are coercing the TRUE/FALSE result of each criteria to
be 1 (for TRUE) or 0 (for FALSE). Here is a link to a great tutorial on
SumProduct. It will answer your question in mucj more detail.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Hope this helps,

Hutch

"Aaron" wrote:

When using Sumproduct as a multiple criteria sumif function, I've seen it
used two ways:

sumproduct(()*()*())

sumproduct(--(),--(),())

My question is are these just two ways of doing the same thing, or does one
do something the other does not?