Makes Sense...thanks for the help

Brian

"KL" wrote:

Well, not exactly. SUMIF does return an array if the second argument is an
array. The question is how do you sum the members of that array. You can, of
course, use the SUM function, but will have to confirm it by
Ctrl+Shift+Enter, whereas SUMPRODUCT doesn't need to be array entered to
handle arrays.